Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
For first time user, first we will upload our previous bank transaction, then we categorize the transaction.
1) Do we need to create new invoices for all previous sales transaction? So that the inventory will be updated too.
2) How to match the uploaded transactions to the invoice?
My point is, I want the uploaded transactions synchronised with the inventory record, sales report and P&L.
@ sharifah
1) Do we need to create new invoices for all previous sales transaction? So that the inventory will be updated too.
If there are only a few sure go ahead and do that, then you have some customer history too. But if there is a bunch, just use inventory adjust, set the adjusting account to COGS and lower the qty of the item previously sold. That will get you current.
Then the work flow in QB is and has always been, enter transactions, download banking, match.
Yes inventory is only reduced when sold on a sales receipt or invoice.
It's nice to see you, @sharifah_nr!
You'll want to create your invoices manually then match them to your downloaded transactions. This way, you can track your inventory accurately.
Firstly, your downloaded transactions don't affect your inventory tracking directly. Thus, manually adding your invoices allow QuickBooks to track your inventory accurately. To do so:
After doing so, you can now go back to your downloaded transactions and match them to your invoices. Let me show you how:
Additionally, here's a couple of articles you can read to learn more about the steps:
If there's anything else that I can help you with, please let me know in the comments. I'll be always around ready to help.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here