Table of Contents
- Introduction
- Why Record Bank Fees in QuickBooks?
- Step-by-Step Guide to Recording Bank Fees in QuickBooks
- Step 1: Go to the Banking Section
- Step 2: Select the Bank Account
- Step 3: Enter Expense Details
- Step 4: Save the Transaction
- Step 5: Reconcile Bank Fees During Bank Reconciliation
- Alternative Method: Use Bank Feeds to Record Bank Fees Automatically
- Steps to Use Bank Feeds
- Creating a Recurring Bank Fee Expense
- Tips for Recording Bank Fees in QuickBooks
- Common Types of Bank Fees to Record
- Troubleshooting Issues with Bank Fees in QuickBooks
- Issue: Bank Fee Not Showing in Reconciliation
- Issue: Incorrect Bank Fee Amount Entered
- Issue: Bank Fee Category Not Available
- Conclusion
Introduction
Bank fees are common expenses for most businesses. They include charges such as service fees, overdraft fees, wire transfer fees, and others that banks charge for various transactions. Recording these fees accurately in QuickBooks is essential for maintaining precise financial records and understanding your true financial picture. This guide will walk you through the steps to record bank fees in QuickBooks, ensuring your books stay up-to-date.
Why Record Bank Fees in QuickBooks?
- Accurate Financial Statements: Bank fees are part of your business expenses and must be recorded to reflect true financial health.
- Tax Deductions: Many bank fees are tax-deductible, so recording them helps reduce your taxable income.
- Clear Cash Flow Management: Tracking bank fees gives you a clear understanding of your cash flow and bank charges.
Step-by-Step Guide to Recording Bank Fees in QuickBooks
Step 1: Go to the Banking Section
- In QuickBooks Online, go to the
+ Newbutton on the left-hand side and selectExpense. - In QuickBooks Desktop, go to
Bankingin the top menu and selectWrite ChecksorEnter Expenses.
Step 2: Select the Bank Account
Choose the bank account from which the fee was deducted. This account should match the one where the fee appears on your bank statement.
- Choose the Bank Account: Select the bank account related to the bank fee.
- Enter the Date of the Transaction: Use the same date as shown on your bank statement for easy reconciliation.
Step 3: Enter Expense Details
Now, you need to provide details about the bank fee to accurately record it in QuickBooks.
- Enter Payee: If your bank is set up as a vendor, select it as the payee. Otherwise, type in the name of your bank.
- Select Category/Account: Choose
Bank Feesas the expense category. If this category doesn’t exist, you may need to create a new expense account for bank fees.
- Account Type: Select
Expenses. - Detail Type: Choose
Bank Chargesor similar. - Name: Enter “Bank Fees” for clarity.
- Add Description (Optional): Add a description of the fee, such as “Monthly service charge” or “Wire transfer fee” for easier tracking.
- Enter the Amount: Input the exact fee amount shown on your bank statement.
- Memo (Optional): You may add a memo for further details about the transaction.
Step 4: Save the Transaction
After entering all the necessary details, save the transaction to record the bank fee.
- QuickBooks Online: Click
Save and Closeto save the expense. - QuickBooks Desktop: Click
Save & Closeto complete the entry.
Step 5: Reconcile Bank Fees During Bank Reconciliation
When you reconcile your bank account in QuickBooks, verify that the bank fees are reflected correctly. This ensures your books match your actual bank statements.
- In QuickBooks Online, go to the
Accountingtab and selectReconcile. - In QuickBooks Desktop, go to
Banking > Reconcile.
- Select Your Bank Account: Choose the bank account you want to reconcile.
- Match Bank Fees: Make sure the bank fee transactions in QuickBooks match those on your bank statement.
If all transactions, including bank fees, match the statement, complete the reconciliation process.
Alternative Method: Use Bank Feeds to Record Bank Fees Automatically
If you have enabled bank feeds in QuickBooks, you can import bank transactions directly, including bank fees. This feature allows QuickBooks to recognize and categorize bank fees automatically.
Steps to Use Bank Feeds
- Enable Bank Feeds: In QuickBooks Online, connect your bank account to enable bank feeds. For QuickBooks Desktop, go to
Banking > Bank Feeds > Set up Bank Feeds for an Account. - Review Bank Transactions: Go to the
Bankingtab in QuickBooks Online or theBank Feeds Centerin QuickBooks Desktop. - Categorize Bank Fees: When QuickBooks imports transactions, find the bank fee and categorize it under
Bank FeesorBank Charges.
> Tip: Double-check the categorized bank fees to ensure accuracy, as QuickBooks might occasionally miscategorize certain charges.
Creating a Recurring Bank Fee Expense
If you incur the same bank fees every month (e.g., monthly maintenance fees), you can set up a recurring expense in QuickBooks to save time.
- In QuickBooks Online, go to
Settings(Gear Icon) >Recurring Transactions. - In QuickBooks Desktop, go to
Lists > Memorized Transaction List.
- Create a New Recurring Expense: Select
New, chooseExpenseas the type, and fill in the details. - Enter Bank Fee Details: Provide the payee, bank account, category (
Bank Fees), and amount. - Set the Frequency: Choose the frequency (e.g., monthly) and set the start date.
- Save: Click
Save Templateto enable the recurring expense.
Tips for Recording Bank Fees in QuickBooks
Bank Fees expense account for clear reporting.Common Types of Bank Fees to Record
Troubleshooting Issues with Bank Fees in QuickBooks
Issue: Bank Fee Not Showing in Reconciliation
- Solution: Double-check that the bank fee was recorded on the correct date and is categorized under the correct account.
Issue: Incorrect Bank Fee Amount Entered
Edit, and update the amount to match your bank statement.Issue: Bank Fee Category Not Available
Bank Fees category, go to your Chart of Accounts, create a new expense account, and name it “Bank Fees” or “Bank Charges.”Conclusion
Recording bank fees accurately in QuickBooks is essential for maintaining clear and precise financial records. By following these steps, you can ensure that every bank-related charge is accounted for, aiding in bank reconciliation, cash flow management, and financial reporting. Additionally, setting up recurring expenses and using bank feeds can simplify the process, saving you time and improving efficiency.
Regularly reviewing and recording bank fees ensures that you have a comprehensive view of your business expenses, helping you make informed financial decisions and maintain a healthy financial outlook.