Import via CSV upload
Importing data from a CSV template
How do you import data via a CSV template?
- You can import financial data directly into Sumday from Transactions using a template CSV file.
- To get started, download the template from the screen when you select CSV or download it here.
- Populate the template, if you have access to your accounting or ERP system this will be simple, if not send this to finance or your accountant.
- Once your transactions are successfully imported, you’ll be directed to the Import Confirmation Screen to review and proceed.
Please avoid modifying the columns or headers in the CSV template. If you don’t have data for the optional columns, simply leave them blank to ensure a smooth import. Modifying these fields may prevent the CSV from importing correctly.
What data is required to populate the template?
- Your financial transaction data s required, as set out in the table below.
- It will usually be in an ERP or accounting system.
- It doesn’t matter what accounting or ERP system you use, you can import your transactions using the CSV upload.
- Simply ensure you extract the data set out below and follow the prompts to upload it into Sumday in the CSV template.
We recommend including transaction reference details in the ‘Description’ column, to provide more context for the Carbon Bookkeeping process.
Field Name | Details | Required/Optional |
Transaction Date | The date the transaction occurred | Required |
Contact | The Supplier/ Customer associated with the transaction | Optional |
Contact Business ID Number | The Business ID number associated with the supplier/customer (e.g NZBN, ABN) | Optional |
Reference | Include the invoice or journal reference number to allow this transaction to be tied back to the source data. | Optional |
Description | The description of the transaction as outlined from the general ledger transaction details | Optional |
Tracking Category | If your organisation uses divisional reporting, this will be the relevant reporting category within your account structure. | Optional |
Account Code | Code, usually numeric, associated with a General Ledger Account | Optional |
General Ledger Account | This is the Name of the Account in the General Ledger. This will be linked to the Account Code above | Required |
Amount | This is the monetary value associated with the transaction | Required |
Transaction Reference | Any other references related to the transaction that may be useful to include. | Optional |
Deleting the import
If you have accidentally imported the wrong data you can delete the data by clicking the little bin icon.
If there is a Lock icon, that means the imported transactions cannot be deleted until transactions have been unassigned from worksheets in the assessments section and unreconciled from ‘Reconciled Transactions’.
Did this answer your question?
😞
😐
🤩
Last updated on September 4, 2024