Results 1 to 3 of 3

Thread: pastel importing

  1. #1
    New Member
    Join Date
    Aug 2014
    Location
    sandton
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy pastel importing

    good day can someone help me to import receipts and payment into pastel cashbook.

  2. #2
    Bronze Member Beancounter's Avatar
    Join Date
    Oct 2011
    Location
    Pretoria
    Posts
    118
    Thanks
    19
    Thanked 29 Times in 24 Posts
    If you're referring to importing from bank statements you can use Pastel's Bank Manager. It is a separate module that you have to purchase and the button appears on the right, at the bottom of the cash book screen. Click it, select the type of file you're importing e.g. Standard Bank CSV, allocate all transactions, indicate VAT if applicable and edit descriptions that you want to appear in the Pastel ledger. Use the Add Mapping button to setup standard descriptions for recurring transactions. Be sure to delete the latter part of the description appearing on the bank statement that contains date or time references. These will differ every month and Bank Manager won't give your set descriptions as it won't find that date and time on following bank statements. Click Save Changes and then Create Batches. Your bank should reconcile.

    I then export my batches to the desktop. Open with Excel and edit the references so that my Pastel references in the cash book follow on the previous month's last reference. I also add some similar transactions together e.g. bank charges so that I only post 1 total to the ledger account. Save as CSV. In Pastel - cash book, click Batch, Import, select the CSV file from your desktop and click process. This is the same process to follow when exporting batches from one set of accounts and importing into another. Just note the contra account must be the cash book account you're importing into and all ledger accounts in the CSV file must be created in Pastel to be imported successfully.

    By exporting a batch from Pastel, you can get the lay-out needed to successfully import from CSV. You can copy and paste the transaction data from another source into Excel and import that too as a batch.

  3. Thanks given for this post:

    Dave A (10-Aug-14)

  4. #3
    New Member
    Join Date
    Aug 2014
    Location
    sandton
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel importing

    Thank you so much, i captured my cashbook on excel i wanted to import to pastel cashbook, i was struggling with the layout

Similar Threads

  1. Pastel General Ledger importing
    By osbert in forum Accounting Forum
    Replies: 8
    Last Post: 10-Dec-15, 10:23 PM
  2. [Question] importing inventory items into pastel
    By StenetteFarrell in forum Accounting Forum
    Replies: 11
    Last Post: 10-Nov-15, 07:04 AM
  3. [Question] Importing into Pastel
    By mtpocket in forum Accounting Forum
    Replies: 11
    Last Post: 04-Nov-15, 11:03 AM
  4. Importing into Pastel Startup V12
    By ultramel123 in forum Accounting Forum
    Replies: 3
    Last Post: 11-Apr-13, 08:59 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •