Import Excel into pastel Cash book

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

[Andria_Bee]

Hi I use Pastel Bank Manager to import our petty cash expenses from excel to pastel, I use three columns date description and amount (all in Text format).
This always worked fine but recently excel has confused I save the worksheet in csv close it when I try to import it I get this bizarre error msg about file format is invalid. When I re-open the excel file the date column automatically changed to date and not text.
All other bank statement imports work fine.....
What am I doing wrong?