Review and confirm transaction import

When importing transactions into Sumday, you can set up Import Rules and map tracking categories before your data lands in your ledger. This workflow allows you to automatically categorize, aggregate, or exclude transactions as they arrive, saving you time during reconciliation.

1. Initiate the Import

1. Navigate to the Transactions tab within your Assessment.

2. Click New import and select your preferred import method (e.g., File Import or a connected accounting integration).

3. Choose your Import period (select either the Entire assessment period or a Custom date range).

4. Click Continue.

2. Set Your Import Rules

During the import process, you will be prompted to set up Import rules to filter out noise and format your data automatically.

1. Click Create your first rule.

2. Use the condition builder to define your logic. For example, select If account is in any of and use the multi-select dropdown to pick accounts you want to filter, such as Wages and Salaries, Depreciation, or Bank Accounts.

3. Choose the corresponding action for those accounts:

   • Drop: Completely ignore the matching transactions.

   • Aggregate: Roll transactions up by a specific interval (e.g., by Month).

   • Set field: Automatically update fields, such as setting sumday.reconciled_as to excluded so they do not impact your carbon reporting.

4. You can string multiple rules together using else if logic to handle different accounts or data fields in a single pass.

5. Click Save and continue.

Typical exclusions include:

• Bank accounts

• Accounts Payable and Accounts Receivable

• Income and revenue accounts (e.g. Sales)

• VAT/GST payment accounts

• Prepayment accounts

• Salaries and wages

• Superannuation or pension payments

• Leave and provision accounts

If you miss excluding an account at this stage, you can still exclude it later within the Carbon Ledger. However, selecting exclusions during import can streamline the process.

3. Map Tracking Categories

If your source data includes tracking categories (e.g., Regions, Departments, or specific file columns), you can map them directly to your tracking categories in Sumday.

1. Review the list of fields pulling in from your import source.

2. Select the corresponding target category in Sumday using the dropdown.

3. If a category doesn't exist yet, click + Create new to add it on the fly.

4. Click Import to begin processing.

4. Track Progress and Review

1. An Imports progress panel will appear on the right side of your screen, showing the live status of your data sync.

2. This panel displays the total number of transactions processed, alongside how many were successfully imported or automatically handled based on your rules.

3. Once the progress bar completes, you will see your updated data in the Carbon Ledger.

Completing the Import

Once you have reviewed your selections and named the import, click Continue. All transactions will then be imported and made available in the Carbon Ledger for reconciliation.