Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHow can I find out exactly which fields in an Item in QB POS are transferred to Quickbooks during Financial Exchange - example: I received and item, put in all information: cost, price, department, description, etc. What of all the information is exchanged to form the financial reports (Balance sheet, etc) I am finding that my inventory balances in Quickbooks do not always matched inventory valuation in QB Point of Sale. I'm afraid that information is being entered incorrectly or in the wrong fields (we have several employees that enter inventory and possibly some do it incorrectly.) Knowing what is involved in getting inventory totals in Quickbooks would be helpful to understanding the problem.
Solved! Go to Solution.
These are two different things.
Now, here's the kicker! If you do inventory qty adjustments, or write new qty's directly into your items, or do a physical inventory count, this changes your POS inventory valuation because of the changed quantity, but it also writes to a different account in QuickBooks Financial for the change in asset value. By default, that account is called "POS Inventory Adjustments." And there you go, your asset account is easily not equal to your POS Valuation now.
Thanks,
Peter Eastvold
POS Expert | Check out our QuickBooks POS Youtubes
As I understand it, inventory is ONLY done in POS. Purchase and sales are done in POS.
Then POS transfers the total of inventory asset to QB, as well as COGS for sales
These are two different things.
Now, here's the kicker! If you do inventory qty adjustments, or write new qty's directly into your items, or do a physical inventory count, this changes your POS inventory valuation because of the changed quantity, but it also writes to a different account in QuickBooks Financial for the change in asset value. By default, that account is called "POS Inventory Adjustments." And there you go, your asset account is easily not equal to your POS Valuation now.
Thanks,
Peter Eastvold
POS Expert | Check out our QuickBooks POS Youtubes
WE Create Receiving voucher in POS
it shows q-ty and cost for every single item in Voucher
then we do Financial exchange with QB
and we got a copy of the Voucher in QB now
but it is totally different document
only the total amount match
but all items cost are absolutely random
why QB changed costs ??????????
Hi there, Andy. I'm here to take care of your concern about the costs of your items with doing a financial exchange.
When performing a financial exchange, data is transferred from Point of Sale (POS) to QuickBooks Desktop (QBDT) and vice versa. QBDT and POS are two different platforms that may have feature differences. To avoid discrepancies and to save data review time, it's recommended to add or edit your items, customers, and vendors in POS only after you have begun sharing data with QuickBooks Desktop.
To get more tips about QuickBooks POS, you can check out this article: QuickBooks Point of Sale (POS) FAQ.
Please let me know how else I can help you with your items costs. I'm more than happy to provide additional assistance. Keep safe!
Angela:
Thank you for your tips on the subject of QB POS not matching QB Desktop. Can you send instructions on how to pull off a report from QB POS with inventory department totals. I need to see how much I am off from POS to my QB Desktop Balance Sheet report?
Thanks
Patti
Thank you for joining this thread, bernardofarmandran.
It can be challenging to reconcile the differences and ensure accurate financial reporting. I'll be happy to guide you through the process of pulling off a report from QB POS with inventory department totals so that you can compare it to your QuickBooks Desktop (QBDT) Balance Sheet report.
Let's run the Inventory Valuation in Point of Sale to give you more accurate data on your inventory. Here's how:
Next, open the Balance Sheet Report in QuickBooks Desktop (QBDT) to compare the data. Here's how:
Additionally, you can make use of this resource to help you with sorting your inventory asset account in QuickBooks Desktop: Balance Sheet and Inventory/Stock Valuation reports show different amounts for Inventory Asset accou....
If you need further assistance with running the report or have other inventory concerns, feel free to visit the Community again and tap my name. I'll be glad to lend a helping hand. Enjoy the rest of the day, bernardofarmandran.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.