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.

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 MX. Use it to import into QuickBooks Online or QuickBooks Desktop.
• .ofx: for accounts connected through MX. Use it to import into Accounting CS and other programs that accept OFX.

For MX accounts, .qbo and .ofx files leave out transactions that are still pending at the bank. 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.
• For Accounting CS, use .ofx.

Need help?

Contact LedgerSync Support at support@ledgersync.com.