How-To

How To Create Customer Retainer Report in QuickBooks Online

For businesses, such as legal and professional design services, that collect retainer fees upfront, here is a report you can build in QuickBooks Online without having the need to create lots of retainer other current liability accounts in your chart of accounts. Be sure you do have one Client Retainer (other current liability type) account

Read More

Build Inventory Assembly Item in QuickBooks Desktop Enterprise

If you have to purchase and track the actual part items used later on for building your final inventory to sell, then here are basic instructions to construct inventory builds in QuickBooks Desktop: Note: this is not for Group type of items. First, to build a basic part inventory (sub) item (note: some item fields

Read More

Create and then Apply Inventory Prepayments in QuickBooks Desktop

If you are having to submit pre-payments for inventory on order (and thus not received yet), then you will need to deduct these prepayments upon receipt of the inventory and corresponding vendor bill. First let’s create the prepayment: Create a new other current asset type of account called “Prepayments on Inventory” (or something like this)

Read More

How to Create a Payroll Moving Reimbursement Item in QuickBooks Desktop Payroll

Open Quickbooks desktop and click on the Lists menu and select Payroll Item List. Note: If payroll is not turned on in your Quickbooks file, then you will not see the Payroll Item List selection. Click on Payroll Item at the bottom of the screen, or simply select Ctrl+N. Select Custom Setup and click Next.

Read More

How to Create a Payroll Bonus Item in QuickBooks Desktop Payroll

Open Quickbooks desktop and click on the Lists menu and select Payroll Item List. Note: If payroll is not turned on in your Quickbooks file, then you will not see the Payroll Item List selection. Click on Payroll Item at the bottom of the screen, or simply select Ctrl+N. Select Custom Setup and click Next.

Read More

How to Apply Customer Credits to Open Invoices in QuickBooks Desktop

Note: This is assuming the customer deposit was already booked BEFORE the payment was actually applied to the customer’s open invoice. Note: This is assuming you do not have your preference setting that makes QuickBooks automatically apply customer credits to open invoices.   Be sure that the pre-existing customer deposit is actually booked correctly for

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 Create an Inventory Quantity Adjustment in QuickBooks Desktop Enterprise

Note: This is assuming your inventory/purchase orders function is active in QuickBooks and you already have an inventory list created with quantities that need to be manually adjusted, perhaps due to a physical count of the inventory. Go to your inventory list in QuickBooks List>Item List Scroll to find the inventory type item that you

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