Tag Archives: Quickbooks online

Advice on Posting Batch Deposits in QuickBooks Online

If you are receiving both check and cash payments from customers, then you will probably be depositing multiple payments during one trip to the bank. To post the entry in your bookkeeping, this requires the use of the undeposited funds account in QuickBooks Online. This particular function can be confusing to understand and utilize in

Read More

How To Reconcile a Bank Account in QuickBooks Online

Here is a video showing how to go thru a basic bank reconciliation process in QuickBooks Online:  

Read More

How to Create a Vendor Profile in QuickBooks Online

Note: Be sure you understand what information to enter for both payment and 1099 purposes. Go to your vendor center in QuickBooks Online (Expenses>Vendors) and then click “New Vendor” in the upper right corner. You will notice the fields First, Middle, Last name AND also the Company AND the field “Display name as”: For payment

Read More

How to Import Bank Transactions from a Spreadsheet into QuickBooks Online

This article addresses how to conduct a manual import of transactions from a spreadsheet into your QuickBooks Online bank feeds center. This does NOT address how to import directly from a bank website. Note: You must first prepare your spreadsheet for the importation of data into QuickBooks Online. Here are some simple tips on how

Read More

How to Reconcile a Bank Account in QuickBooks Online

This article addresses how to reconcile to a bank statement closing balance. A closing balance is best viewed by printing out a monthly (a month-close) PDF closing bank statement. This is because an official monthly closing statement can (but not always) calculate all of the withdrawals and deposits and sum these up onto the monthly

Read More

Accounts Payables – Clearing Out Vendor Credits in QuickBooks Online

Here is a video showing how to apply an old vendor credit to a new vendor bill:

Read More

How to Apply Vendor Credits to Open Bills in QuickBooks Online

Note: This article addresses only applying old credit balances to newer open vendor bills. Note: This article assumes you do NOT have the “Automatically apply bill payments” setting turned on in your QuickBooks company settings. If one of your vendors currently has a credit (negative) balance in your books, then let’s create a new bill

Read More

How To View Unpaid Bills and Open Accounts Payables in QuickBooks Online

There are different ways of viewing a report in QuickBooks Online that will show open vendor liability and credit balances. Please note: Your QuickBooks Online subscription may prevent you from having access to certain reports. So let’s begin: Go To>Reports>Reports Scroll down to the section under “What you owe” Click on Unpaid Bills Note: when

Read More

How to Write Off Uncollectible Accounts Receivables (Bad Debt Expense) in QuickBooks

There are different ways of handling the issue of writing off open Accounts Receivables due to customers not paying you for whatever reasons. This issue can also be resolved differently if you are an accrual or cash basis tax filer and also if the Accounts Receivables to be written off (to a Bad Debt Expense

Read More

How to Apply a Customer Payment to an Open Invoice in QuickBooks Online

You received a customer check payment and it is sitting on your desk and now you want to apply this payment to a specific open invoice. Go to Sales>Customers Find the customer in the list and click to open the customer’s transactions list. Scroll thru and find the invoice that you want to apply payment

Read More