CSV file upload for Q2 - can this be done to save hours inputing each line item again and again?

Question asked by John Fleming 5 days ago

My Q1 and Q2 submissions are near identical. Can i use the CSV file I download from the site from my Q1 filing - adjust the excel file to reflect Q2 reality then re-upload the CSV to my clear books account to auto-populate Q2 and save me doing each entry line by line for again? It seems this is possible on your platform but when I upload the excel csv file for Q2 I get error messages such as 'row cannot be empty' even if there is no cost for that property in that line and with 0 entered. If this were possible this would be magic and save hours each quarter. The properties and income expense definitions or classifications don't change so it should be possible? Best, John

1 Reply

Hi John,

Unfortunately, it is not possible to import your income and expenses on the Property plan. Instead, you can import bank statements and explain your transactions directly within your account. When bank transactions are brought in, explaining them is the process of matching those bank lines to your records or categorising them into the relevant income or expenditure accounts.

As you explain transactions, the system will create import rules based on the transaction description and your explanation of the contact and account code so that if future transactions have a matching description, the system will automatically explain these.

Where the transaction slightly differs each transaction such as having dates or some numbers after the description, you can customise the search term on the bank explain screen like so:

file

Alternatively, you can customise historic transactions under Settings > Import rules. The import rules feature is a great tool for automating the explanation of recurring transactions on bank statements.

Tommy

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