Upload bank or card activity from a CSV

One Feed Per Account

Every bank or card account has one card in Bank Feeds. A card can be connected to the bank, used with files only, or both. Rows from the bank and rows from your uploads sit in the same list and are handled the same way: rules, Tally's suggestions, automatic posting, tabs, and posting.

Rows waiting in a feed are not on the books until they are posted.

Add A Feed

If the account has no card yet:

1. Open Bank Feeds for the company and choose Add feed.
2. Choose Existing account and pick any bank, card, or other balance sheet account from your Chart of Accounts that has no feed yet. Or choose New account and enter its name, type, and last four digits.
3. Choose Connect bank to sign in to the bank, or Files only to upload files. Files only opens the upload right away.

The account then shows in Chart of Accounts with the green bank-feed outline, whether it is connected to the bank or files only. Picking an existing account adds no new account to your chart.

You can connect a bank to a files-only card later from its three-dot menu.

Upload The File

1. On the account's card, open the three-dot menu and choose Upload CSV.
2. Download a CSV, OFX, or QFX file from the bank's website, then drop it in or choose the file.

Any dates work, including dates the bank feed already covers.

If LedgerHQ cannot find the date or amount column, it asks you to choose the columns, starting from its best guess. Your choice is remembered for the next upload to that account.

Review Before Adding

Nothing is added until you confirm. The review shows how many rows are new, how many are exact copies already added by an earlier upload, and how many look like possible duplicates of rows already in the feed.

Check the sample amounts. Some card files list charges as positive numbers. If charges show as money in, select Flip signs before you add anything.

• Exact copies (same date, amount, and description as a row an earlier upload already added) are skipped. Uploading the same file twice adds nothing, and an overlapping file adds only the new days. Two real identical charges in one file stay two rows.
• Possible duplicates are added and marked. A file row and a bank row (or a row from another upload) with the same amount within 3 days are paired, and both show a Possible duplicate pill.

If the file has a running balance column, the card shows the last File balance and its date.

Handle Possible Duplicates

1. Post the row you want to keep from each pair.
2. Choose Exclude possible duplicates above the list. It excludes the leftover partner of every posted row and tells you how many pairs still need one side posted.

Excluded rows can be restored from Excluded.

Upload History And Remove

The card's three-dot menu opens Upload history: each file, when it was added, rows added, exact copies skipped, rows posted, and rows still waiting.

Remove deletes the upload's rows that are still waiting. Rows already posted or reconciled stay, and LedgerHQ lists them so you can decide what to do with each one.

Disconnect Or Hide

• Disconnect bank keeps the card and every waiting row. The card becomes files only, and you can keep uploading.
• Hide feed takes the card off Bank Feeds. A connected card asks you to disconnect and hide. Its waiting rows are kept unposted and come back exactly as they were when you choose Show under Hidden feeds.