Document Explorer: Importing a CSV-file
If you or your client records their tax return in a spreadsheet you can import individual items into the Record Keeping section. If your client prefers not to connect a bank feed you can also import bank statements directly.
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’
How to import
Go to Record Keeping and select Import Document
Select Upload new document and Import
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 APARI column headers
Select Import to finalise the upload
The data will be added to your unassigned transactions.
NOTE: from the Document Explorer page/dashboard, you can also preview, download and delete documents.
Related Articles
AI document extractor
Our brand new AI DocExtractor uses cutting-edge technology to help you save time on your time heavy tasks processing clients documents. Easily upload documents and see the extractor create and categorise transactions ready for you to review and ...
Record Keeping Overview
The Record Keeping Section helps you keep track of your clients transactions in a digital format. Transactions can be automatically uploaded directly from your clients bank feed, imported by CSV-file or manually added. Adding transactions manually ...
Adding a new client
You can add new clients in two ways, individually or in bulk. Adding clients individually is ideal for adding a small number of clients and for larger numbers you should add multiple clients using our CSV-file client importer. Setting up individual ...
Tax return download & SA302
You can download a complete PDF of your client's tax return at any point in the workflow. The PDF contains both the SA100 form and the SA302 tax calculation document. How to Download Go to Tax Submission → Select tax year → Tax Submission Overview ...
Creating Transaction Rules
Transactions can be imported directly from bank feeds, importing bank statement CSV's, from uploaded documents and/or adding transactions manually. Once transactions are in ApariPro you can categorise them in a few ways, either when manually adding ...