Results 1 to 5 of 5

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
    140
    Thanks
    21
    Thanked 33 Times in 27 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

  5. #4
    New Member
    Join Date
    Mar 2019
    Location
    Plumstead
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Beancounter View Post
    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.
    Besides manually retyping the bank amounts after the cashbook entries have been created to ensure that the debtor and creditors invoice matching is correct, is there any other way to auto allocate for choose an invoice allocation in the process?

    Thanks
    Sean

  6. #5
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Quote Originally Posted by Seanb17 View Post
    Besides manually retyping the bank amounts after the cashbook entries have been created to ensure that the debtor and creditors invoice matching is correct, is there any other way to auto allocate for choose an invoice allocation in the process?

    Thanks
    Sean
    On each line of the journal, press the F3 function key to invoke the Match Open Item window.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

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
  •