Import Excel into pastel Cash book

[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.

[simonj]

I provide Document Imaging Solutions and today I met with a client who wants to scan Creditor invoices and have them allocated to the relevant expense account.
That's not a problem for me at all. My software will use OCR to extract various data and write it to a table and use the index data to generate folders, sub folders and file names for the scanned image. Where the challenge comes in is where he wants the table data delivered to Pastel. He already has the expense accounts set up in Pastel and currently has the data manually captured. Although I regularly employ Pastel reports to gather index data, I have never had to do it the other way round. I personally don't have any experience using accounting software of any sort, but I instruct my clients on what reports they need to set up so that I can find index data in the resulting spread sheet.
So. My question is simply; how do I format the data and what are the steps required to pass it to the various expense accounts in Pastel? I do understand from other posts that it needs to be in CSV format.

Thanks in advance. Understanding this will add a whole new dimension to my solutions as most of my clients appear to be using Pastel.

Simon Jooste.

[Neville Bailey]

Hi Simon,

I would be happy to work with you on this project. Hopefully we can both benefit from the exercise! Drop me an email and we can take it from there.


Sent from my iPhone using Tapatalk

[simonj]

Thanks Neville.

My process would be something like this:
1.User scans multiple invoices from assorted creditors to a set folder.

2.System displays the scans one at a time and prompts for various data. (Where possible, the fields will be prefilled via OCR for validation by the user)

3.The data is written to an Access table. An internal query will find the relevant data to be exported. An external (.csv as per your layout) table will be linked to it.

There you have the data ready to go to Pastel!

From here I'm in your hands as I am completely unfamiliar with accounting systems of any sort.......

Thanks Neville

[Neville Bailey]

Hi Simon,

Can you email me at neville@accountingsoftwaresupport.co.za and we can proceed from there?

[Yeukai]

Hie, i am Yeukai i am a junior accountant, im still learning a
lot of accounting staff. Iam sure this forum will be of great assistance, thank you.