[Question] CSV Template to Upload in Pastel Xpress Cash Book

[StuMurless]

Does anyone have a CSV template to upload bank transactions into Pastel Xpress Cash Book.

I am looking to do what Pastel Bank Manager achieves without the add on.

I want a template so that I can download my bank statement in CSV format and then transfer the data into the template and upload it into Pastel thus cutting out the manual data entry.

[Neville Bailey]

I have attached a PDF document that describes the CSV layout requirements, as well as a sample cashbook payments journal, in CSV format.

[StuMurless]

Thanks Neville. Do you use Pastel Bank Manager and if so would you recommend it. From what I understand you would have to pay for Pastel Cover every year as well as the once off purchase of Bank Manager.

[Neville Bailey]

Yes, I do use Bank Manager and I can highly recommend it, as rules can be set for the automatic account allocation (including VAT or not) of transactions with certain strings of characters in the reference.

You are quite correct regarding the requirement of Pastel Cover (for your entire Pastel setup, not only the Bank Manager module). I personally have an issue with this policy, but that's the way it is, I'm afraid.

Let me know if you would like me to send you a quote.

[Yeukai]

I am trying to ipmort a payments batch from excel to my cashbook debit side, i am failing, may you please help help me.