I just started using QuickBooks and i want to go back to the beginning of this year and enter all my data. How can i invoice products that are not in inventory?

puertasportalmex · ‎November 14, 2024

We sell doors and each door has a lot of small parts on it that i dont want to enter, so instead i want to invoice as complete doors. The door pricing will vary also cost per door will vary how can i enter the doors so that it will still report cost and profit

JorgetteG · ‎November 14, 2024

Invoicing complete doors with varying prices can be managed effectively, and I'm here to help you track your costs and profits, Puertasportalmex.

When invoicing products that aren't part of your inventory, such as complete doors and their various small parts, it's beneficial to use Non-Inventory Items in QuickBooks Online.

This method streamlines the invoicing process by allowing you to include complete doors without the need to list each small component individually, all while effectively tracking your costs and profits.

Here's how to get started:

Invoicing Products Not in Inventory:

Navigate to the Sales section in the left panel menu, then select Products & Services.
Click on the New button in the top right corner and choose Non-Inventory from the options provided.
Enter the item name (for example, "Complete Door"), a description, and the initial selling price.
Enter the purchase cost in the designated field. If the price varies, you may leave this blank and update it each time you invoice.
Finally, click Save and Close to finish.

Tracking Costs and Profits:

Create Invoices:
- When you create an invoice for a door, select the non-inventory item you created (e.g., "Complete Door").
- Enter the sale price for the specific transaction.
- Update the cost field with the actual cost of that door for accurate profit tracking.
Run Reports:
- Go to the Reports menu, search for Profit and Loss, and select the Report Period to see your overall sales income and costs.
- Go to the Reports menu, search for Sales by Product/Service Detail, and choose the appropriate report period to see detailed information on sales and costs for each product/service.

Furthermore, you may want to consider browsing these articles to manage your products and personalize your reports in QuickBooks Online:

If you have any further questions or need more help managing your data in QuickBooks Online, please leave a reply below. We're here to assist you in making your bookkeeping as smooth as possible.

Chrea · ‎November 14, 2024

@puertasportalmex

You should prepare your historical sales data as Sales Receipt (not Invoice) and you can import them in bulk.