Import Excel into pastel Cash book

[ultramel123]

Hi :-)

I would like to find out whether it is perhaps possible to type out the entries for the cashbook into excel, and then import them into Pastel?
I am using PastelStartup V12.

Thank you

Regards

[Neville Bailey]

Yes, it is possible, but you will need to save the Excel file in CSV format and the data must be arranged in a particular format.

I have attached the format requirements.

To import the CSV file, open a blank cashbook journal. Then click on the Batch button, and then the Import option. You can then browse for the CSV file.

[ultramel123]

Thank you very much Neville. This is going to make my life sooooooo much simpler,as I have tons of months to still capture.

[Neville Bailey]

Have you considered getting the Bank Manager module? Makes life even easier!

[ultramel123]

I have heard about it... would you perhaps know roughly what the cost is?

[Neville Bailey]

There is an initial cost of R2,550.00 incl VAT, and thereafter an annual Cover fee of R2,059.00 incl VAT.

I can supply you with the module if you are interested.

[ultramel123]

let me discuss it with my client, and I will get back to you :-) Thank you very much.
That would really make life easer :-)

[Neville Bailey]

Bear in mind that the quote I gave you is based on the assumption that you are using Xpress V12 Xpress Startup (single-user, single-company).

[ultramel123]

ok great. thank you. I will hear what the "boss" says :-)

One more thing - if you wouldn't mind assisting please

when importing the csv into the cash book - (payments) - must I include the "tax" amount in the column, or leave that column blank for pastel to calculate?

[Neville Bailey]

I have always included the VAT amount in the "Tax" column, but I think Pastel will automatically calculate it by virtue of the Tax Code that you will have in the CSV file.

Perhaps do a test import without the VAT amount and see what happens.

[ultramel123]

Thank you .
When capturing the "Payments" in the cash book, must they be a "-"negative value in excel for importing? and the "Receipts" be a positive value?

[ultramel123]

Thank you.

Are the "payments" in the cash book a (-)negative value, and the "receipts" a (+)positive value? :-)

Thank you for your help

[Neville Bailey]

No, not necessary. All the values must be positive.

[jhodgson]

I have set up a system which generates invoices, and stores these in the pastel csv structure format for import into pastel.
The import, general leger-cutomers-receipts-batch-import works fine.
the result is a credit to the customer and a debit in cash control 0850000.

Now if I do an identical invoice, through the Pastel receipting module,I end up with a duplicate credit to the customer and a duplicate in the cash control, however with a different receipt number.

I now go to the deposit assistant, create a new session, and then make a deposit slip etc.
The deposit slip ONLY contains the receipt entered through the pastel receipting module.

Please note that: The upload file works whether it has a suffix csv or txt as long as the format is right. My filename is simply Receipt.txt.

The reason for using .txt is that it opens automatically in Notepad. CSV opens in excel, and when excel closes and saves it the format is wrong for pastel. As the users doing the work are not very skilled this cuts down on the errors.

What must I do to get the Deposit assistant to recognize the imported receipt and include it in the session and deposit slip?

[Neville Bailey]

Before I attempt to answer your questions, I have a question of my own.


You mention that you import invoices into the Receipting module, and that it credits the customer account and debits the cash control account. This confuses me. An invoice normally debits the customer account and credits sales. Are you sure that you are importing invoices and not receipts? Receipts would make more sense, as that would credit the customer account and debit the cash control account.


Please clarify this for me and also please send me a sample of the file that you import.