Solved

Workflow from inventory received to credit-card and vendor payments

Forum|Forum|6 years ago
May 22, 2020
2 replies
0 views

Background:

First time setting up an online retail business.
First time doing everything under the sun for building and growing my business.
First time QB Desktop Premier user.
Zero accounting background.

What works:

I got my inventory into QB (excel import) and manually added the QTY on hand.
I got my products built along with the costs of their materials.
I got my pricing set-up
I understand the Discount item and Price level parts

I plan to run an online retail business and my material purchase patterns will mirror exactly the above. The question is...

How do I track the payments I ALREADY made (via credit card) for the inventory parts I used to build my products across various vendors? I buy parts from online storefronts and the payment is made immediately; I wait a few days for the inventory to arrive. I am familiar with the PO/Bill concept and transaction concept, but I just don't understand the whole reconciliation process with credit card payments already made. Again, I purchased inventory parts already and built my products.

The workflows that I am confused about are:

Just purchased inventory and paid for it; how do I sync that with QB
Just received inventory from vendor; how do I sync that with QB

I am getting ready to start my online business and sell. Before I start taking orders of my products via my e-commerce channels, I want to make sure I get my QB setup right. THANK YOU.

QuickBooks Desktop

Best answer by KlentB

Thanks for choosing QuickBooks as one of your partners in building your business, sjangity.

I'm here to clear things out for you.

When we record items in the program, we'll have to use PO and bill then Receive Inventory instead of directly entering the quantity on hand of the item. This way, we'll be able to correctly tie the inventory to your payments.

To make sure that everything is accurate, we'll have to delete the inventory item then recreate it with zero on hand. We can create an inventory adjustment to zero out its quantity on hand. First, let's create a separate account in your chart of accounts to track your adjustments:

Select Company from the top menu bar, then select Chart of Accounts.
Click the Account drop-down, then select New.
From the Other Account Types drop-down, click Cost of Goods Sold.
Name this account “Inventory Adjustments”, and then Save and Close.

Then, we can now create an inventory adjustment:

Select List from the top menu bar, then choose Item List.
Go to Activities, then select Adjust Quantity/Value on Hand.
Click Find & Select Items and check the box for the inventory item you wanted to adjust.
Click Add Selected Items, then enter the account you've created for the adjustment in the Adjustment Account drop-down.
Enter zero in the New Quantity column and click Save & Close.

Once done, let's make this item as inactive to remove it in your Item List. Simply go to List and select Item List. Then, right-click the item and select Make Item Inactive.

After that, we can now enter the credit card payments and inventory parts you've used to build your products from your vendors:

Select Vendors from the top menu bar, then go to the Vendor Center.
Choose then right-click the appropriate vendor.
Select Enter Credit Card Charges.
Go to the Items tab, then select Add New from the Item column.
Enter the necessary information, make sure to leave the quantity on hand as zero.
Click Save & Close when you're done.
Enter the cost, amount, and description of the item, then click Save & Close.

For the inventory that you've just purchased and received, we can use the Accounts Payable workflow in recording it. I'll guide you how:

Wonder how to check if the status of your inventory is accurate and up-to-date? We can pull your Inventory Stock Status by Item report. Here's how to do it:

Select Reports from the top menu bar.
Choose Inventory.
Select Inventory Stock Status by Item.
Look for the items you've added/adjusted and make sure everything is correct.

To know more about how credit card payments reconciliation works in QuickBooks, you can read our guide to help keep your accounts accurate.

I'm always here and ready to work with you again if you have other questions about handing inventory transactions. Have a great rest of the day.

KlentBAnswer

Thanks for choosing QuickBooks as one of your partners in building your business, sjangity.

I'm here to clear things out for you.

When we record items in the program, we'll have to use PO and bill then Receive Inventory instead of directly entering the quantity on hand of the item. This way, we'll be able to correctly tie the inventory to your payments.

To make sure that everything is accurate, we'll have to delete the inventory item then recreate it with zero on hand. We can create an inventory adjustment to zero out its quantity on hand. First, let's create a separate account in your chart of accounts to track your adjustments:

Select Company from the top menu bar, then select Chart of Accounts.
Click the Account drop-down, then select New.
From the Other Account Types drop-down, click Cost of Goods Sold.
Name this account “Inventory Adjustments”, and then Save and Close.

Then, we can now create an inventory adjustment:

Select List from the top menu bar, then choose Item List.
Go to Activities, then select Adjust Quantity/Value on Hand.
Click Find & Select Items and check the box for the inventory item you wanted to adjust.
Click Add Selected Items, then enter the account you've created for the adjustment in the Adjustment Account drop-down.
Enter zero in the New Quantity column and click Save & Close.

Once done, let's make this item as inactive to remove it in your Item List. Simply go to List and select Item List. Then, right-click the item and select Make Item Inactive.

After that, we can now enter the credit card payments and inventory parts you've used to build your products from your vendors:

Select Vendors from the top menu bar, then go to the Vendor Center.
Choose then right-click the appropriate vendor.
Select Enter Credit Card Charges.
Go to the Items tab, then select Add New from the Item column.
Enter the necessary information, make sure to leave the quantity on hand as zero.
Click Save & Close when you're done.
Enter the cost, amount, and description of the item, then click Save & Close.

For the inventory that you've just purchased and received, we can use the Accounts Payable workflow in recording it. I'll guide you how:

Wonder how to check if the status of your inventory is accurate and up-to-date? We can pull your Inventory Stock Status by Item report. Here's how to do it:

Select Reports from the top menu bar.
Choose Inventory.
Select Inventory Stock Status by Item.
Look for the items you've added/adjusted and make sure everything is correct.

To know more about how credit card payments reconciliation works in QuickBooks, you can read our guide to help keep your accounts accurate.

I'm always here and ready to work with you again if you have other questions about handing inventory transactions. Have a great rest of the day.

S

sjangityAuthor

How can I reset my entire Item List? I've exported my list (for backup) and would like to re-import? Also, when I tried to delete a product item, it complains that the Qty on Hand > 0. I must have "built" some products. I really just want to start over on the Item List instead of hiding and re-creating the list, if that makes sense?

AlexV

Good day, sjangity.

You're unable to delete or make the inventory inactive if there's still a remaining quantity on hand. You can delete the inventory adjustments to zero out the quantity on hand. Then, we can now delete it.

Go to the Lists menu and select Item List.
Select the item, right-click, and select the QuickReport.
Double-click on the inventory transactions.
Click the Edit menu and select Delete Inventory Adjust.

I have some articles here for more details about items:

Please leave a comment again if you have other concerns. Have a great day!

MariaSoledadG

Inventory features in QuickBooks Online are available in the Plus and Advanced version, DMalt.

QuickBooks Online (QBO) tracks what's on hand, get alerts when it's time to restock and see insights on what you buy and sell. To do this, you'll have to turn on inventory tracking and add your inventory products

Then, you can keep track of what you sell and restock your inventory. You can also use reports so you can easily check the status of your inventory. For more information and detailed steps of the setup, please read this article: Set Up And Track Your Inventory In QuickBooks Online.

Although there might be some features that are only available in QuickBooks Desktop, you'll want to use a third-party app that allows retailers, e-commerce, and wholesale small business owners to manage their inventory and sales channels easily. This includes the workflow from inventory received to credit-card and vendor payments.

For future reference, you'll want to run reports to see your sales and inventory status. Please check this out: Use Reports To see Your Sales And Inventory Status.

Fill me in if you have further questions. I'll always be right here to help you.

Sign up

Login with SSO

Login to the community

Login with SSO