You can import financial data directly into Sumday from the Transactions screen using a template CSV file.
Where to find your financial data?
- It will usually be in an ERP or accounting system - your finance team or accountant may need to assist you with accessing this. See a guide for to request their assistance here.
- It doesn’t matter what accounting or ERP system you use, you can export the data from the system to a CSV, Excel or JSON file to import into Sumday
- Simply ensure you extract the required data set out below and follow the prompts to upload it into Sumday
Data required for a successful import
💡 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 |
| 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 |
| 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 |
| Transaction Reference | Any other references related to the transaction that may be useful to include. | Optional |
How to access the import screen:
- Login to Sumday
- Select Assessments, open the assessment you need to import transactions into
- Click Transactions at the top of the screen
- Click New import
- Select File upload to upload a CSV without needing a template
- Select Continue
Once your transactions are successfully imported, you’ll be directed to the Import Confirmation Screen to review and proceed.
CSV Template Upload tips
⚠️ 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.
💡 Be sure to save the file as "CSV (Comma delimited) (*.csv)" only. Using "CSV (Semicolon delimited) (.csv)" or "CSV UTF-8 (Comma delimited) (.csv)" will result in errors.
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’. More information in our article here.