.qbo) file directly from the transactions page. CSV works with any spreadsheet or accounting tool, while .qbo is intended for QuickBooks Online and QuickBooks Desktop.
If you want Lemma to sync directly with your accounting software instead, see Accounting integrations.
The Export button lives at the top-right of the page.
Export your transactions
1
Choose your entity
Transactions are automatically filtered to your current entity. If you
manage multiple legal entities, use the entity switcher to select the right
one before exporting.
2
Apply filters (optional)
Use the filter bar to narrow the transactions shown on the page. You can
filter by search term, date
range, account, method, and direction. Any filters you set will carry over to
your export.
3
Click Export
Click the Export button in the top-right corner of the page, then choose
CSV or QuickBooks (.qbo). Your browser will download a
transactions.csv or transactions.qbo file.Importing into QuickBooks
In QuickBooks Online, open Transactions → Link account and click Upload from file. Select your.qbo file. In QuickBooks Desktop, use File → Utilities → Import → Web Connect Files and select the downloaded .qbo file.
What’s included in the export
- CSV
- QuickBooks (.qbo)
One row per transaction. The file includes only the columns you checked, in the order below.TransactionYour account
required
When the transaction occurred, formatted as
YYYY-MM-DD in your timezone.When the transaction occurred, formatted as
YYYY-MM-DD HH:MM in your timezone.A summary of the transaction.
The signed amount in US dollars, without a currency symbol or thousands separators (e.g.
1234.56 or -450.50). Money out is negative.Credit for money in, Debit for money out.The transaction’s status:
Posted, Pending, Held, Needs approval, or Failed.The kind of transaction, such as an ACH transfer, wire, or check.
The category assigned to the transaction. Defaults to “Uncategorized”. Blank for transactions that can’t be categorized.
For transactions with a hold, the date the funds are released, formatted as
YYYY-MM-DD.Who you sent money to or received money from. For transfers between your own accounts, includes the other account’s name and last four digits.
The number a payer’s remittance file quotes for the payment. Use it to match deposits against remittance files. For inbound ACH payments, this is the payer’s TRN trace number. For deposited checks, this is the check number. Blank for all other transactions.
The name of the account the transaction belongs to.
The last four digits of the account number.