Import Bank Transfers into QuickBooks Online the Right Way

To import bank transfers into QuickBooks Online correctly, upload both accounts' files as usual, then mark the line in the account the money left as a transfer to the receiving account. On the receiving account, match the incoming line to that transfer instead of adding it. One transfer then covers both sides, with no false income or expense.

Why an imported bank transfer turns into income and an expense

An imported bank transfer looks like two unrelated payments. Your checking statement shows money leaving, and your savings statement shows money arriving. Each upload brings in its own line, and nothing in either file says the two lines are the same money. Categorized one at a time, they become an expense and a sale.

That mistake inflates both sides of your profit and loss report. Income goes up by the transfer amount, expenses go up by the same amount, and profit looks unchanged, so nothing seems wrong. The damage shows up later, when sales figures do not match invoices or a tax preparer asks why revenue jumped.

A transfer is neither income nor an expense. It moves value between two accounts on your balance sheet. QuickBooks Online has a transaction type for exactly this, and Intuit's help page on transferring funds between accounts recommends entering a transfer as a single transaction that affects both accounts, not as two separate entries.

One sample transfer, seen from both accounts

Here is one made-up transfer of $2,000 from checking to savings, and what each upload brings in.

The point of the table is the last row. Two lines come in, but your books end up with one transaction.

Recording the bank transfer from the source account

Start with the account the money left. Open its line in the review list, set the transaction type to Transfer, choose the receiving account, and record it. QuickBooks then writes one transfer that reduces the source account and increases the receiving account at the same time.

These steps follow Intuit's transfer help page, which covers matching imported bank transactions once both accounts have been downloaded or uploaded. Menu names shift between QuickBooks versions, so expect small differences.

1. Upload the files for both accounts for the same date range. Intuit's manual upload help page covers that part, including the rule to start each file the day after the last transaction already in the account.
2. Go to Bank transactions and select the source account, the one the money left.
3. Open the transfer line, such as the -2,000.00 in the example.
4. Change the transaction type to Transfer.
5. Pick the receiving account, such as Savings, as the other account.
6. Select Record transfer.

Starting from the source side is a habit, not a rule. What matters is that you record the transfer on one side only and match it on the other.

If the descriptions are consistent, a bank rule can speed this up. Text such as "ONLINE TRANSFER TO SAV" repeats every month, and a rule that sets the type to transfer and picks the savings account saves the clicks. Check what the rule did before you accept the lines.

Matching the other half of an imported bank transfer

The receiving account's line is already covered by the transfer you just recorded. Do not categorize it. Find it in that account's review list and choose Match, which links the uploaded line to the existing transfer. Your books then hold one transaction, and the bank line is marked as accounted for.

Intuit's transfer page describes this step: open the destination account, go to the For review tab, filter by Recognized, find the line and select Match in the action column.

If QuickBooks does not suggest the match, check three things:

• The amount. A transfer with a fee attached may arrive as 1,995.00 on one side and 2,000.00 on the other. Record the fee separately, then match.
• The date. Transfers between banks can take a day or more. A gap of a few days is normal, but a much larger one may push the line outside the range QuickBooks searches.
• The account. If the receiving file was uploaded to the wrong account, the match has nothing to find. Fixing transactions imported to the wrong account explains how to move them.

When nothing works, you can search for the transfer manually from the line and pick it yourself. Search by the exact amount first. The descriptions on the two statements rarely share any words, as the sample table shows with TO SAV 7781 on one side and FROM CHK 4402 on the other.

What if only one account in the bank transfer is in QuickBooks Online?

If only one account is in QuickBooks Online, the other side of the transfer needs an account to point at anyway. Set up the missing account, even with no uploads, so the transfer has somewhere to go. Never book money to or from your own account as income or an expense just because the other account is not tracked.

This comes up in a few common ways:

• A savings account you never connected. Create a bank account for it with its opening balance. Transfers from checking will build up its balance, and you can upload its statements later.
• A personal account. Money from your business account to your personal account is usually an owner draw, and money the other way is an owner contribution. Those are equity accounts, not bank accounts. Ask your accountant which ones your books use.
• A loan or line of credit. A loan payment is partly a transfer to the loan account and partly interest. It is not a plain transfer of the full amount.

If the other account appears in QuickBooks later, its upload will bring in lines that should match the transfers you already recorded. Match them rather than adding them.

Which payments are bank transfers in disguise?

Several kinds of payment are transfers even though they do not say "transfer" on the statement. A credit card payment, money moved to a payroll account and cash taken out for a petty cash box all move value between accounts you own. Each should be recorded as a transfer, not as an expense.

• Credit card payments. The money leaves checking and reduces the card balance. The purchases on the card were already recorded as expenses, so booking the payment as an expense counts them twice.
• Payroll funding. Some businesses move money to a separate payroll account before payday. The move is a transfer. The wages, taxes and fees paid from the payroll account are the expenses. Importing payroll transactions covers how to record those.
• Petty cash top-ups. An ATM withdrawal or a check cashed to refill the cash box moves money from checking to a petty cash account. The spending is recorded when cash leaves the box. Importing petty cash transactions shows the setup.
• Transfers by check. Writing a check from one of your accounts to another is still a transfer. Intuit's transfer page suggests recording it as a check with its number, with the receiving account as the category. Importing checks with their check numbers covers how check numbers carry through an upload.

A quick test for any line: did the money leave the business, or did it stay in an account you own? If it stayed, it is a transfer.

Undoing a bank transfer already posted as income

A transfer that was posted as income on one side and as an expense on the other needs both entries fixed. Change one of them into a transfer to the other account, then remove the second entry and match its bank line to the transfer. The result is one transfer, and both registers keep their bank lines.

Find the pair first. Run a report of income for the period and look for deposits whose descriptions mention a transfer or your own account numbers. Then look in the other account for an expense of the same amount on or near that date.

To repair one pair:

1. Open the posted expense on the source account and undo it, which sends the bank line back to the review list.
2. Do the same with the posted income on the receiving account.
3. Record the source line as a transfer, as described above.
4. Match the receiving line to that transfer.

Undoing posted lines rather than deleting them keeps the bank lines available for matching. If an entire upload went in wrong, it is often quicker to undo the whole upload and bring the file in again.

Check each month after a fix. Income on the profit and loss report should be close to your actual sales, and balances in both accounts should match their statements. If you build the upload files yourself from PDF statements, SimpleBankConvert is being built to produce them with one signed amount column, which makes the out and in sides of each transfer easy to spot.