Tag Archives: quickbooks

Convert PDF Transactions to Spreadsheet for Import into QuickBooks

This article addresses the issue of conveniently importing credit card transactions into your QuickBooks company file, but from a PDF type of file. Sometimes (for whatever reasons), you may not be able to obtain a convenient spreadsheet download (or from a bank feeds connection) of your credit card transactions, but instead are able to obtain

Read More

How to Post a Payroll Tax Liability Adjustment in QuickBooks Desktop

This article addresses how to post a payroll tax liability adjustment in QuickBooks Desktop.   Here is the scenario: You received your annual Texas state unemployment tax rate notice that informs you of what your effective tax rate will be for the upcoming calendar year. Unfortunately, this notice did not arrive until well after the

Read More

QuickBooks Desktop Report that Shows How AR Payment was Applied

This article addresses how to create a report in QuickBooks Desktop that shows specifically which customer invoices you applied a customer’s payment to.   Here is the scenario: You received a customer’s payment and applied this payment to multiple invoices. Perhaps some time later (days, weeks, etc) the customer is now requesting a report that

Read More

Create a Customized Balance Sheet by Job report in QuickBooks Online

This report is simply a convenient way to view the capitalized costs (non-expensed) associated with each customer/job, separated out (and displayed) per column of information, but, of course, all on one report. This report, perhaps, would be convenient for industries such as speculative home building but can be useful for anyone that is especially interested

Read More

Tracking Investments Bookkeeping – Part 2

Part 2 in this series of tracking investments in your QuickBooks Desktop file will only cover tracking your cost basis of your paper investments.   For each type of equity holding that you purchase: Example: 50 shares of XYZ, Inc. at a market price of $2/each = a value of $100 cost basis. I like

Read More

How To 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

How To 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 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 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 Set Up an Employee Deduction Health Insurance Payroll Item in Quickbooks Desktop

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. You will need to create a new payroll item for the employee deduction portion of an employee’s health insurance plan,

Read More