Imported statement

Question asked by Nadia Akhtar 8 years ago

Hi, I have uploaded a CSV bank statement / payment run How can i change the import date? although the data i have uploaded shows a date of the 16th of October the transaction itself shows a date of 01 Jan 70. How can this be changed?

file

Also after importing information into Clearbooks the data is in ascending order lowest transaction value to the highest rather than the order in which it was imported (Screenshot attached). Can i stop this happening?

file

Thank you in advance,

Nadia

Write reply4

4 Replies

Hi Nadia,

From what I can see to answer your first question (the issue with the date) will be caused by an entry error in the CSV file that you are using to upload into Clear Books. This is evident as its not only the month that is off, the year is also registered as 70. If you review and update this detail in the file this should resolve this issue once the statement is deleted and reimported.

Unfortunately, there is not currently a way to reorder the transactions in an imported statement. This is functionality that we are looking to implement but is not yet available. You won't be able to stop this at present.

A workaround would be to increase the number of results displayed per page allowing you to display all transactions on the same page and pair them off as you go.

I hope this helps, Theo

Best answer
8 years ago

Hey Thanks for the prompt response - I will have a look at this next week when i do the next payment run :D

Thanks Theo have a great day.

Nadia

8 years ago

Good Morning Nadia,

If you would like funds to sit in a supplier/customer account this can be achieved by applying the account code trade creditor/debtor respectively.

You may be required to toggle these account codes on so that they will display when allocating payments. This is done by heading to Settings > Accounting > Account codes. You will have the option to enable for purchases and/or sales.

I hope this is helpful, Theo

8 years ago

Good Morning Theo,

Thanks for getting back to me. The CSV column containing date was not formatted corrected dd mm yy. Also it would be good to be able to add an entity so the funds sit on the supplier / customer account.

Thanks for your help have a good day,

Nadia

8 years ago

Reply to this question

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are

Apps

Company

Social