Skip to Content
BooksBookkeepingImporting transactions

Getting transactions into Books

Import a bank statement into Transaction Coding or connect a bank feed. Select the correct client and bank account before importing so the records land in the right workspace.

Import a statement

  1. Open Bookkeeping → Transaction Coding.
  2. Select the bank account.
  3. Click Import to open Import Bank Statement.
  4. Choose the file and follow the displayed format requirements.
  5. Review the extracted transactions and select the rows to import.
  6. Confirm the import and wait for processing to finish.
  7. Check For Review for the imported transactions.

The importer supports CSV data and supported bank-statement PDFs. For a PDF, check the Supported Banks list in the upload screen. Review extracted dates, descriptions, and amounts before confirming.

Prepare a CSV

Open CSV Format Guide from the importer. The supported layouts are:

LayoutColumns
Separate money out and money inDate, Description, Spent, Received
Signed amountDate, Description, Amount

In a single Amount column, negative amounts represent spending and positive amounts represent receipts. Debit/withdrawal and credit/deposit aliases are also accepted. Use a consistent date format and inspect the preview before importing.

Review the outcome

The results report imported transactions and skipped rows. Processing can also categorize imported records. Keep the import window open while it asks you to wait, then inspect the suggestions in For Review.

Correct a failed file or skipped rows before trying again. Check the existing transactions before repeating an import so you do not review the same statement twice.

Use a connected bank feed

Open Bookkeeping → Bank Accounts to connect and map bank accounts through Plaid. Refresh a connected account to retrieve available activity, then review the imported records. See Plaid bank feeds.

Last updated on