The Record Keeping Section helps you keep track of your transactions in a digital format. Transactions can be automatically uploaded directly from your bank feed, imported by CSV-file or manually added.
What can I do in Record Keeping?
Adding transactions manually
You can add individual transactions to their Record Keeping to ensure all transactions are digitally logged and included in the tax return.
How to add a manual transaction
Go to Record Keeping and select Add Transactions Manually
Select Income or Expense
Enter the description, recipient, business source and category
Choose the Account and input Date and Value
Mark as refund if applicable by changing the slider
Attach receipt/ invoice and add notes if required
Select Add transaction to save
Importing a CSV-file (spreadsheet)
If you don't have a bank feed or have a record of transactions from a spreadsheet you can import your spreadsheet on bank CSV statements directly into the software.
CSV-file checklist
Save the spreadsheet as CSV-file, this is possible from most devices
Ensure all cells are formatted as text
Ensure no rows are empty
Delete any ‘Total’ rows or rows where the transaction value is ‘0’
Use the software spreadsheet template
Download the software CSV template
Copy and paste your transactions into the structure
Save the file as a CSV
How to import
Go to Record Keeping and select Import CSV-file
Select the transaction source from the dropdown
Select Choose File to upload your CSV, then click Continue
Map the fields by matching your file headers to software column headers
Select Import to finalise the upload
The data will be added to your unassigned transactions.
Assigning Transactions
Once your bank feed is connected and the transactions are fed into the software, you can allocate them to the correct categories which will update the correct boxes on your tax submission form. This will allow you to keep on top of your income and tax-deductible payments such as business expenses, charitable donations and pension contributions.
To view Unassigned Transactions: Go to the Record Keeping section and select View All to see the unassigned transactions.
Select Transactions to Assign: Select the circle next to the transaction(s) you want to assign. You can assign them individually or group them together by selecting multiple transactions. You can filter the unassigned transactions by name, date, bank account, income or expense.
Choose Business Source & Category: From the dropdown menus in the bottom right corner, select the appropriate Business Source and Category for the transaction(s). Select Apply to confirm and assign the transactions.
By selecting the 3 dots on the transaction and selecting Edit you can also add notes and upload an invoice/ receipt to a transaction by uploading via browse files or dragging and dropping your file into the upload box.
Splitting a transaction
If you have a transaction that falls into multiple sources or categories you can split the transaction appropriately. By selecting the 3 dots on the transaction and selecting 'Split' you can then assign the correct proportions to each category including splitting transaction into income and expenses eg. split a single transaction from a letting agent into gross rent and their management fee.
Private Transactions
If your transaction doesn’t relate to your Self Assessment Tax Return, or they don’t want it included, you can either delete the transaction or set the Business Source and Category to Private.
Export Data
You can export a data file of your reviewed transactions which will include all the transaction information from the Date, Account Business, Income and Expense category and transaction value.
You can export the reviewed transaction data by going to Record Keeping and selecting Export Data under reviewed transactions. You can use the search bar or filter button if you wish to create an export of certain transactions like expenses or by date period, when the desired filters have been set select Export Data.
Please use the in depth articles in this section for more help on each of these actions, there are also video's attached to offer further help.
If you are still unsure or need further help you can contact your accounting firm or our Digital Tax Software support team by submitting a ticket at the bottom of the page.