Quickbooks: Why You Need To Connect Your Bank Account

do i need to connect bank quickbooks

Whether or not to connect your bank account to QuickBooks is a common question. It is possible to use QuickBooks without linking your bank account, and some people prefer to do so to avoid potential double charges or security concerns. However, connecting your bank account can make many tasks much easier and save you time, especially if you are running multiple businesses.

Characteristics Values
Is it necessary to connect your bank account to QuickBooks? No, it is not necessary. You can maintain your register, write and record checks, and other transactions without connecting your bank account.
Is it recommended to connect your bank account to QuickBooks? Yes, it is recommended as it makes many tasks much easier.
How to manually add bank transactions without connecting your bank account? You can download a CSV file from your bank and upload it manually into QuickBooks.

bankshun

Manual input of transactions

QuickBooks is accounting software that allows you to manage your business's income and expenses. You can use QuickBooks to record your income and expenses without linking your bank account. This can be done by manually entering transactions.

To enter transactions manually, you can go to the "Chart of Accounts/Registry/-Line" and enter the information manually one by one. You can write checks on the check screen for payments and record deposits on the deposit screen for receipts. For credit card transactions, you can enter them via the "Enter Credit Card Charges" screen, which looks like a check.

If you want to keep things organised and ensure reports reflect correctly, you can use Bank Feeds to help categorise transactions. Go to "Banking" and then "Bank Feeds Centre". Select your bank account and choose "Enter Transactions Manually". For checks, go to "Banking" and then "Write Checks". For deposits, go to "Banking" and then "Make Deposits".

If you have been importing files and want to continue manually entering transactions, you can use third-party tools like CSV2QBO or Zed Axis to convert CSV files into QuickBooks-importable QBO files. Alternatively, you can use the free app QuickConverter.app to convert your bank transaction files (CSV, QBO, etc) into a format that expired QuickBooks Desktop can import called IIF.

bankshun

Automating bank feeds

Step 1: Connect Your Bank Account

Go to Bookkeeping in QuickBooks, then select Transactions and Bank Transactions. If it's your first time connecting, select Connect Account on the landing page. Search for your bank and link your account. Most banks and even small credit unions can be connected seamlessly.

Step 2: Set Up Bank Feed Rules

Once your bank account is connected, you can set up rules for automating your bank feeds. This involves giving each rule a name, typically the name of the vendor or customer. You then select whether it's "money coming in" (income/sales) or "money going out" (expenses). Choose the account you want to monitor, and select whether the transaction should meet All or Any of the conditions. You can then specify whether the transaction contains, doesn't contain, or is exactly as per your criteria.

Step 3: Review and Categorize Transactions

QuickBooks will automatically import transactions from your bank feeds. It's important to review these transactions for accuracy. Check dates, amounts, and vendors, and categorize them appropriately. Over time, QuickBooks will learn from your inputs and recommend categories for your expenses, making the process even more efficient.

Step 4: Automate Recurring Invoices

In addition to bank feeds, you can also automate recurring invoices in QuickBooks. This feature ensures that you get a clear view of what you make and spend over time, improving your overall workflow process.

By following these steps, you can fully automate your bank feeds in QuickBooks, making financial management more efficient and reducing the risk of errors.

bankshun

Recording income and expenses

Recording Income

To record income in QuickBooks Desktop, you can create a Sales Receipt. Go to the Customers menu, then select Create Sales Receipts/Enter Sales Receipts.

Recording Expenses

To record expenses in QuickBooks, you can either use manual or automated methods. Expenses are identified from any transaction made through debit card, credit card, bank transfer, net banking, or online payment and must be recorded.

Automated Method

To automate expense recording, you can email digital receipts or bills to your QuickBooks account or use the mobile app to snap and upload receipts directly. First, log in to QuickBooks Online and click on the left menu to choose Banking and Receipts. Then, select the option to register your email. After that, attach your appropriate paperwork and send it in the body of an email.

Manual Method

For manual expense recording, go to Expenses > Expenses to edit, review, or delete entries. To edit an expense, find the expense, select View/Edit, make the necessary changes, and then Save and Close. To review expenses, run an Income by Customer Summary report from Reports. To delete an expense, select View/Edit > Delete, and confirm your choice.

If you plan to bill your customer for an expense, editing the expense will affect the invoice you send them. To record personal expenses from an account through a vendor set up as a bill, create a journal entry to record the business expenses paid with personal funds. Then, choose a reimbursement method, such as recording it by check or expense.

What Type of Lender Are Banks?

You may want to see also

bankshun

Reconciling without adding an account

You can reconcile in QuickBooks without adding a bank account. If your account isn't connected to online banking, you can manually add service charges or interest earned during the period.

Firstly, select the account you want to reconcile from the Account dropdown menu. Ensure that the account you select matches the one on your statement. If you see a message about a past reconciliation, you must fix this before you start.

Next, verify that the beginning balance in QuickBooks matches the one on your statement. If they don't match, you'll need to fix any errors. Enter the ending balance and ending date on your statement. Some banks refer to the ending balance as the "new balance" or "closing balance".

If you have QuickBooks Online Plus or Advanced, your Reconcile page will have AI-powered reconciliation features built-in. You can still manually reconcile by choosing not to upload a bank statement and selecting "Start reconciling" after filling in the ending date and ending balance information.

If the listed transaction in QuickBooks matches your statement, check it off. This marks it as reconciled. If you're sure there's a match but something small is wrong, select the transaction in QuickBooks and then select "Edit". Make edits so the details match your statement. If a listed transaction in QuickBooks isn't on your statement, leave it unchecked. When you're finished, the difference between your statement and QuickBooks should be $0.00. If it is, select "Finish now".

Note that if you have connected a bank account to QuickBooks Online, your transaction info comes directly from your bank. In some cases, your accounts may already be balanced. Make sure the dates entered for each transaction in QuickBooks match the dates for each transaction in your account statement. If there are any missing QuickBooks transactions, select "+ New" and add the transactions you need.

bankshun

Security concerns

Security is always a concern when it comes to linking your bank account with any third-party application. QuickBooks Online (QBO) is designed with advanced security measures to keep your data private and protected. It utilizes industry-recognised security features to provide secure online banking, allowing you to manage your transactions with confidence.

QuickBooks employs bank-level security protocols, including encryption, multi-factor authentication, and automatic data backup to secure servers. It also utilizes advanced fraud detection technology to identify and prevent unauthorized access to your account. The connection and information from your bank are \"read-only\", meaning QuickBooks can only read your transactions and cannot process payments or extract personal information. Additionally, QuickBooks asks for your online banking credentials (user ID and password) to establish a one-way communication with your bank, ensuring that information only goes from your bank to QuickBooks and not the other way around.

However, despite these security measures, some users have reported instances of their bank accounts being hacked after linking them to QuickBooks. It is important to note that these reports may be isolated incidents, but they are worth considering when evaluating the security concerns of connecting your bank to QuickBooks.

To enhance security, you may want to explore setting up ACH Positive Pay, which provides an additional layer of protection against unauthorized ACH debits. Additionally, ensuring that your banking platform is enabled for QuickBooks is crucial, as some banks may view these logins as a security threat if not properly set up.

Frequently asked questions

No, it is not necessary to connect your bank account to QuickBooks. You can maintain your register, write and record checks, and other transactions without connecting your bank account.

Connecting your bank account to QuickBooks can make many tasks much easier. It simplifies bookkeeping, spend policies, reimbursements, and receipt tracking.

To connect your bank account to QuickBooks, you can download a CSV file from your bank and upload it manually into QuickBooks.

Written by
Reviewed by
Share this post
Print
Did this article help you?

Leave a comment