To download a client's transactions, open Bank Connections > Transactions, choose the bank or account, tick the transactions you want, then click Download and pick a file type. This works for bank accounts connected through MasterCard and MX, and every file type (.csv, .qbo, .ofx and .pdf) is available for both.

Transaction downloads on this page are not available for accounts connected through Statements & Checks. If you only have PDF bank statements, use Tools > PDF Converter instead (see below).

Download transactions from a connected bank account

1. Select the client in the client list on the left.
2. In the top menu, click Bank Connections, then Transactions.
3. In the bank and account box at the top left, choose the bank connection. You can pick the whole connection or a single account under it.
4. To limit the dates, click the filter icon on the right side of the page. In the Filter Transactions panel, set the date range and click the green check mark to apply it.
5. Tick the checkbox next to each transaction you want. To select all of them, tick the checkbox at the top of the checkbox column.
6. Once at least one transaction is selected, a bar with action buttons appears above the list. Click Download and choose the file type.

Your browser then downloads the file, usually to your Downloads folder.

Which file type to choose

• .csv: for accounts connected through MasterCard or MX. Use it for spreadsheets or any custom import.
• .qbo: for accounts connected through MasterCard or MX. Use it to import into QuickBooks Online or QuickBooks Desktop.
• .ofx: for accounts connected through MasterCard or MX. Use it to import into programs that accept OFX files.
• .pdf: for accounts connected through MasterCard or MX. It gives you a readable report of the selected transactions, grouped by account.

Pending transactions

For MasterCard accounts, downloads include only transactions the bank has posted. Transactions that are still pending are left out of every file type.

For MX accounts, .qbo and .ofx files leave out transactions that are still pending at the bank. If every transaction you selected is still pending, no file is created and a message tells you why. After the bank posts them, select those transactions and download them in a new file.

Convert PDF bank statements

The PDF Converter turns statement PDFs into files you can import. Click Tools in the top menu, then PDF Converter, and upload your statement PDFs. When a file shows COMPLETED, click Export in its row and choose a format. For the full steps, see the article How to Convert Bank PDF Statements to Excel, CSV, QBO, or OFX.

Good to know about the Transactions page

• The list shows the bank, the account name and the account number for each transaction, so you can see where it came from.
• A Memo column shows the memo the bank sent, when the bank provides one.

Tips

• If a .qbo import into QuickBooks Desktop gives you errors, see the article How to Fix Transaction Import Issues with QuickBooks Desktop.

Need help?

Contact LedgerSync Support at support@ledgersync.com.