Tag Archives: Quickbooks online

Create a Customized Profit & Loss by Job report in QuickBooks Online

This article addresses how to create a customized Profit & Loss by Job report in QuickBooks Online. This report is simply a clear and convenient way to view the profitability of all of your customers/jobs, separated out (and displayed) per column of information, but, of course, all on one report. This report, perhaps, would be

Read More

Altering a Service Item in QuickBooks Online

This article addresses the issue of what to do when you discover one of your service items is not booking transactions correctly to your chart of accounts. Perhaps you reviewed a Profit and Loss report and discovered the following scenario:   One of your Cost of Goods Sold accounts has a huge negative balance.  

Read More

Create Service Item in QuickBooks Online

Here is a video showing how to create a service item in QuickBooks Online:

Read More

How to Create a Basic Service Item in QuickBooks Online

If you need to create a basic service item to use to create a future customer invoice in QuickBooks Online, then here are the steps:   Click on the gear icon (upper right), the click on Products and Services under the Lists menu. Click New Choose “Service” Fill in the appropriate fields to be able

Read More

How To Apply Vendor Credits to Open Bills in QuickBooks Online

Note: This article assumes you do NOT have the “Automatically apply bill payments” setting turned on in your QuickBooks company settings. Let’s say you process an Unpaid Bills report and get the following results for one of your vendors: Vendor has an unpaid bill in the amount of $300. Vendor ALSO has an unapplied credit

Read More

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