LedgersLab
Log inStart free
OverviewFusion AIInvoicing & paymentsBank reconciliationReportsInventoryAll featuresPricingHelp CenterFAQBlogContact
Log inStart free

8.4Importing bank transactions

Chapter 8 · Banking·1 min read

For accounts without a live feed, or to back-fill history, import the bank's statement file:

  1. Open the account and click Import transactions.
  2. Click or drag the statement onto the upload area. Supported formats: PDF bank statements, Excel, CSV, MT940 and CAMT.053. The format is detected from the file.
  3. For CSV and Excel a Preview of the first rows appears with a column-mapping form: Date column *, Amount column *, Description column and Reference column. LedgersLab guesses the mapping; correct it if needed and say whether the first row is a header.
  4. Click Import. Lines that already exist (same date, amount and reference) are skipped, so re-importing an overlapping statement does not create duplicates. Imported lines land in Pending review, ready to categorise exactly like a feed.
4.8Importing contacts from a fileOn the Customers or Vendors list click Import (or use the Overview's Import customers / Import vendors). Click Download template to get a CSV with the…Contacts — customers and vendors8.2Bank and cash accountsAdding an account Bank, cash and credit-card accounts are accounts in your chart of accounts with the type Bank, Cash or Credit Card. There are two ways to…Banking8.3The bank account pageThe header shows the account name with a Plaid feed or Manual tag, Last sync, Code, Pending review, Last txn and Reconciled (the date the account is…Banking8.7Bank rulesBank rules categorise incoming lines automatically. Rules run in order — lower Order numbers run first; the first matching rule wins. A match shows as a…Banking