🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Business & Cross-Cutting › Bookkeeping / Office Administration › QuickBooks for Bookkeeping & Office Administration › Lesson 5
BUS-BOOK55-02 · Lesson 5 · 14 clock hours · lab

Banking: Bank Feeds, Transfers, and Reconciliation

Objective. Students will connect a simulated bank feed, categorize downloaded transactions, record transfers between accounts, and complete a bank reconciliation with a $0.00 difference.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a credentialed professional in the field or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

Banking in QuickBooks Online: Bank Feeds, Transfers, and Reconciliation

One of the most powerful features of QuickBooks Online (QBO) is its ability to pull transaction data directly from your financial institution — or accept a manually uploaded file — so you spend less time on data entry and more time verifying accuracy. This lesson covers the full banking workflow: importing transactions, categorizing them, recording transfers, voiding checks, and completing a bank reconciliation to a $0.00 difference.

Understanding Bank Feeds

A bank feed is a connection between QBO and your bank that brings transaction data into the Banking (or Transactions) center. When a live connection is not available — such as in a training environment — you can upload a file in OFX (Open Financial Exchange) or CSV format using the manual import tool. Navigate to Banking > Upload transactions, choose the correct account, and map the columns (date, description, amount) before confirming the import.

Once transactions appear in the For Review tab, they are not yet recorded in the books. You must review and accept each one. QBO uses bank rules — criteria you define based on payee name, amount range, or description text — to suggest a category automatically. Always verify the suggested category before accepting; a misrouted transaction creates an error that will surface at reconciliation time.

Categorizing Downloaded Transactions

For each transaction in the For Review tab you have three choices:

1. Match – QBO found an existing entry (such as a manually entered bill payment) that matches the downloaded item. Matching links them so no duplicate is created.

2. Categorize (Add) – No existing record exists; you assign an account code and add it to the ledger.

3. Exclude – The item is not a real transaction for your books (for example, a duplicate download). Use this sparingly and document your reason.

Accuracy in categorization is critical. Assigning a personal expense to an operating account, or posting a loan repayment to an expense instead of a liability, produces financial statements that misrepresent the business. When in doubt, refer to the chart of accounts and consult your reconciliation scenario packet.

Recording Bank Transfers

When money moves between two company accounts — for example, from a checking account to a savings account — you record a Transfer rather than a deposit and an expense. In QBO, go to + New > Transfer, select the account money is coming From, the account it is going To, the amount, and the date. Save the transfer. When both accounts have bank feeds active, the same transfer will appear in both Banking centers; match each side to the single transfer record to avoid creating duplicate entries.

Never record an inter-account transfer as an income item or an expense. Doing so overstates both revenue and expenses and will cause the reconciliation to fail.

Voiding a Check in QBO

Voiding a check is not the same as deleting it. Voiding keeps an audit trail: the check remains in the register with a $0.00 amount and the notation VOID, preserving the check number in sequence. To void in QBO, locate the check in the register or through the Search function, open it, click More > Void, and confirm. Never delete a check unless it was entered in error and the check number was never issued, because deletion removes all record, making future audits difficult.

Bank Reconciliation

Bank reconciliation is the process of confirming that the balance in your QBO register matches the balance on the bank statement after accounting for outstanding items. Follow these steps:

1. Go to Accounting > Reconcile and select the account.

2. Enter the ending balance from the bank statement and the ending date.

3. QBO displays all uncleared transactions. Check off each item that appears on the bank statement.

4. Watch the Difference field in the upper right. Your goal is $0.00.

5. If a difference remains, look for: transactions entered at the wrong amount, missing transactions, duplicate entries, or a transfer recorded on only one side.

6. When the difference reaches $0.00, click Finish Now and print or save the Reconciliation Summary.

A reconciling difference that you cannot explain should never be forced to zero by posting a journal entry to an adjustment account without authorization. Investigate first; document any legitimate adjustment with a memo explaining the reason.

Data Accuracy and Security

Always log out of QBO when stepping away from a workstation — browser sessions left open expose financial data to unauthorized access. In a shared lab environment, use only the practice account assigned to you; never view or alter another student's file. Keep your login credentials private. These habits reflect the professional standards expected of a bookkeeper and are consistent with the data-security principles tested on the QuickBooks Certified User exam.

Passing the Lab Check

Your printed Reconciliation Summary must show a $0.00 difference. Before printing, verify that all 20 imported transactions are in the Categorized (or In QuickBooks) tab — none should remain in For Review. Confirm that the two transfers appear on both account registers without duplicates, and that the voided check shows $0.00 in the register. The instructor will review your file for duplicate entries before signing off.

Key terms10

Bank FeedAn automatic or manually uploaded connection that brings bank or credit card transaction data into the QBO Banking center for review and categorization.
OFX / CSV ImportFile formats used to manually upload bank statement transactions into QBO when a live bank connection is unavailable; OFX is a structured financial format and CSV is a plain comma-separated spreadsheet.
For Review TabThe holding area in the QBO Banking center where downloaded or imported transactions wait until they are matched, categorized, or excluded by the bookkeeper.
Bank RuleA saved condition in QBO that automatically suggests a payee name and account category for downloaded transactions that match specified criteria, reducing manual data entry.
TransferA QBO transaction type used to move funds between two company bank or savings accounts; it must be recorded as a transfer — not income or expense — to keep both account registers accurate.
VoidThe process of zeroing out a check or transaction in QBO while retaining its record and check number in the register for audit purposes, as distinct from deleting the entry entirely.
Bank ReconciliationThe monthly process of comparing QBO register balances against the bank statement, checking off cleared items, and investigating any remaining difference until it reaches $0.00.
Reconciling DifferenceThe dollar amount shown during reconciliation between the QBO cleared balance and the bank statement ending balance; a completed reconciliation requires this figure to equal $0.00.
Reconciliation SummaryThe QBO report printed or saved at the end of a successful reconciliation; it lists the statement ending balance, cleared transactions, and confirms a $0.00 difference.
Outstanding ItemA transaction recorded in QBO that has not yet cleared the bank — such as an uncleared check or a deposit in transit — and therefore does not appear on the current bank statement.

Worked examples4

1. After categorizing all transactions, your reconciliation shows a Difference of -$45.00 (QBO balance is $45.00 less than the bank statement). How do you find and fix the error?
  1. Step 1 — Confirm the statement ending balance you typed matches the paper statement exactly; a keying error here is the most common cause of a reconciling difference.
  2. Step 2 — Sort the reconciliation transaction list by amount and look for a $45.00 item that is checked (cleared) but should not be, or an unchecked item that has already cleared the bank.
  3. Step 3 — Compare each checked item on screen against the bank statement line by line; if a $45.00 transaction appears on the bank statement but is missing from the QBO register, it was never entered — add it now with the correct account code.
  4. Step 4 — After adding or correcting the transaction, return to the Reconcile screen; the Difference field should update to $0.00.
  5. Step 5 — Click Finish Now and print the Reconciliation Summary confirming $0.00 difference.
Answer: The $45.00 difference was caused by a missing transaction. Once it is added to the register and cleared in the reconciliation screen, the Difference field reads $0.00 and the reconciliation is complete.
2. You transferred $2,500.00 from Checking to Savings on March 15. When you open the Savings bank feed, a $2,500.00 deposit appears in For Review. What is the correct action?
  1. Step 1 — Do not click 'Add' (Categorize) for this item; adding it would create a second, duplicate $2,500.00 entry in the Savings register.
  2. Step 2 — Click on the downloaded item; QBO should suggest a Match to the transfer you already recorded. Review the date and amount to confirm they agree.
  3. Step 3 — If a match is suggested and correct, click Match to link the bank feed item to the existing transfer record.
  4. Step 4 — Open the Checking account bank feed and repeat: locate the $2,500.00 debit and match it to the same transfer record.
  5. Step 5 — Verify that both registers show exactly one $2,500.00 transfer entry and that no duplicate appears.
Answer: Match the bank feed item on each side of the transfer to the single Transfer record in QBO. This produces one transfer entry in each register with no duplicates.
3. Your bank statement shows an ending balance of $8,340.00. QBO shows cleared deposits of $12,000.00 and cleared payments of $3,660.00. What is the cleared balance QBO will display, and does it match the statement?
  1. Step 1 — Calculate the QBO cleared balance: Beginning cleared balance + Cleared deposits − Cleared payments. If the beginning balance was $0.00 for this example: $0.00 + $12,000.00 − $3,660.00 = $8,340.00.
  2. Step 2 — Compare to the bank statement ending balance: $8,340.00 (QBO) vs. $8,340.00 (statement).
  3. Step 3 — Difference = $8,340.00 − $8,340.00 = $0.00.
Answer: The QBO cleared balance is $8,340.00, which equals the bank statement ending balance of $8,340.00. The Difference is $0.00 and the reconciliation is complete.
4. Check #1042 for $215.00 was entered in error (the check was never written or issued). Should you void or delete it, and what steps do you take?
  1. Step 1 — Because the check number was never issued on paper, deletion is acceptable here; however, confirm with your supervisor before deleting any check to follow office policy.
  2. Step 2 — If company policy requires retaining all check numbers in sequence (common for audit trails), void the check instead: open check #1042, click More > Void, confirm. The register will show $0.00 and the notation VOID.
  3. Step 3 — If deletion is authorized, open the check, click More > Delete, and confirm. Document the reason in a memo or audit log.
  4. Step 4 — After voiding or deleting, return to the reconciliation; the $215.00 item will no longer appear as an outstanding check, so verify the Difference field still reads $0.00 (adjust other cleared items if necessary).
Answer: For a check number never issued, deletion may be appropriate with supervisor approval; for an issued but incorrect check, always void to preserve the audit trail. Either action must be documented.
In class: Upload a provided OFX/CSV bank statement into QBO using the manual import tool; categorize 20 downloaded transactions by matching rules and account codes. · Record two bank transfers between checking and savings accounts, and record a voided check following QBO's proper void procedure. · Run the Bank Reconciliation module against the provided statement ending balance; investigate and correct any discrepancy; print the Reconciliation Summary.
Materials: QBO trial account, simulated OFX bank statement file, reconciliation scenario packet, QuickBooks Certified User Study Guide (banking chapter)
Check: Printed Reconciliation Summary shows $0.00 difference; instructor verifies all 20 transactions are categorized and no duplicate entries exist; pass = $0.00 reconciling difference.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

QuickBooks Certified User – Banking
1. After uploading an OFX file into QBO, imported transactions first appear in which tab of the Banking center?
QuickBooks Certified User – Banking
2. Which QBO transaction type should you use when moving $3,000 from a company checking account to a company savings account?
QuickBooks Certified User – Banking
3. When a downloaded bank feed transaction matches an existing manually entered bill payment in QBO, the correct action is to:
AIPB Certified Bookkeeper – Internal Controls and Recordkeeping
4. A bookkeeper voids a check instead of deleting it. What is the primary advantage of voiding?
AIPB Certified Bookkeeper – Bank Reconciliation
5. During bank reconciliation, the Difference field shows -$120.00. The most likely cause is:
AIPB Certified Bookkeeper – Bank Reconciliation
6. Your bank statement ending balance is $5,200.00. QBO shows cleared deposits of $9,800.00 and cleared payments of $4,600.00, with a beginning cleared balance of $0.00. What is the reconciling difference?
QuickBooks Certified User – Banking
7. Which of the following best describes a bank rule in QuickBooks Online?
AIPB Certified Bookkeeper – Ethics and Internal Controls
8. A student leaves a QBO practice session open on a shared lab computer while stepping away for a break. Which professional and security risk does this create?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.
← Previous lessonProgram planNext lesson →