Importing a journal

Question asked by Saman Fernando 10 years ago

Hi ,

I was looking to import journal entries, how can i get the CSV format for import?

I am unable to export the journal to see the format.

5 Replies

Hi Saman,

Below is the journal template - make sure to use the same date and description for each journal you import

file

Hi Graeme,

They are separate journals as per the description and totals. Each journal's debits and credits must balance.

Tommy

??? His journal has lines with 01/03/15, 0503/15 and 10/03/15. Or are you counting those as individual journals and his screenshot is showing multiple journal import?

Hi Graeme,

As per John's screenshot, each journal must have the same accounting date.

Tommy

In a normal journal the accounting date is taken from the header so has to be the same on each line. I notice in your example there are different dates. So is that OK in an imported journal?

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