Limited time. 50% OFF QuickBooks for 3 months.
Buy now & saveHi,
I use QBKS 2019 for Desktop Mac.
I have entered many GJs and allocated most lines to different Vendors. When I check Vendor records in Vendor Quick Reports and Vendor Center, most GJs don't show up.
For example, Vendor XYZ has about 100 transactions via 20 GJs but on the Vendor record only two of the 20 GJs show up. What am I doing wrong? I checked various Vendors, it is the same across the board, and inconsistent. Plus it is not always the same two GJs that show up. Seems to be random. I did set the search criteria to All Transactions.
Thanks in advance.
Solved! Go to Solution.
Journal entries should be the exception when using QB, they often do not work as you think they should, and when you use inventory type items they never work for inventory. It is much better to use the forms on the home page the way QB is designed to be used. Journal entries also bypass accrual/cash reporting, and will not show on many reports.
The vendor transaction listing only shows bills entered, if you pay a vendor without entering a bill that payment does not show there. A purchases report by vendor will show it all though
Most transactions have a source line and a non-source line. General Journals are a little different in that there really isn't a distinction. There might be bug in how the Vender Center or the QuickReports are looking for them. Do the ones that show up have the Vendor portion of the GJ in the first line of the General Journal record? And do the others have it in a line that isn't the first?
Thank you for your reply, and yes, that is exactly the case! The only line from any GJ that shows on a Vendor record is the first line. None of the other GJ lines show on Vendor records. To me, that sounds like a bug!
I wonder what to do next...
Journal entries should be the exception when using QB, they often do not work as you think they should, and when you use inventory type items they never work for inventory. It is much better to use the forms on the home page the way QB is designed to be used. Journal entries also bypass accrual/cash reporting, and will not show on many reports.
The vendor transaction listing only shows bills entered, if you pay a vendor without entering a bill that payment does not show there. A purchases report by vendor will show it all though
Hi Rustler, thanks for your reply. Yes, I understand about the use of GJs. I have been using QBKS for Windows since it came out in the 80ties, and there was never a problem with it then as far as I recall. Perhaps it is different for the Mac version, as there are quite a few things that are different, for example no Multiple Currencies feature.
As for the vendor records, they also update when I go through Banking/Write Checks, not just with Bills.
In the meantime I have hundreds of transactions in GJs for an entire accounting year that don't do what I thought they would do. Hm. Guess I have to Write Checks for all those transactions for the next year.
I believe it is the same in QuickBooks Windows. We are looking into it but what Rustler says is the best approach. I have a CPA that gives me a handful of journal entries and even those cause the problems Rustler describes.
Thanks everyone for your help. I completely understand that QBKS is not as flexible as I had in my mind...
Actually, I did check that with a friend in the Quickbooks for Windows version, and yes, in Windows it works. Every line in a GJ that has a vendor or customer allocated shows up in the vendor or customer record. So there must be some glitch in the Mac version. I will find a way to bring this up with Intuit, somehow. Thank you!
PS. I have used QBKS for Windows for many years, and the GJ funcion always included posting to the Vendor record. Actually, I did check that with a friend in the Quickbooks for Windows version today, and yes, in Windows it works. Every line in a GJ that has a vendor or customer allocated shows up in the vendor or customer record.
So there must be some glitch in the Mac version. Any idea how I bring this up with Intuit,? Thank you!
I appreciate you getting back to us, lokita.
Allow me to help and provide you with some information about showing every line for General Journal in QuickBooks for Mac.
In order to show every line in a general journal in the report, you will first need to make sure that the filter is set to Name only.
Here's how:
If you're still unable to show all the line in a general journal, you can reach out to our QuickBooks Desktop Support to help you investigate this further. Our contact details can be found here along with our opening hours:
You may find this article helpful:
Let me know how it goes if you have any other questions about the general journal. Have a good one.
I use QBDT for Windows and not every line of JE show up in vendor transactions despite all being coded to the vendor within the JE. Very frustrating.
Hello, LOCUSCO.
Viewing the list of line items of the journal entry on the Vendor transactions page is a great functionality. Allow me to provide insights about this matter.
In QuickBooks Desktop, the Vendor transactions page only displays the first line item of your journal, even if all the lines are associated with a vendor. This feature works as designed.
As a workaround, I recommend manually opening the entries to view all the line items. Here's how:
Alternatively, you can run and personalize a report. Here's how:
Please keep me posted anytime if you require further assistance with QuickBooks Online. My goal is to ensure that you achieve your desired outcomes with bookkeeping.
That is for desktop, but how can you get the GJ entries to be included in the transaction list on the vendor home page in Online version? Only the expenses show up for each vendor
Thanks, Cathy
It's nice to have you here in the Community, Cathy.
I'm here to address your concern about including Journal Entries in the vendor home page transaction list in QuickBooks Online (QBO).
To start with, May I know how you created or entered the Journal Entry? The accounts used in creating a journal entry determine whether or not the entry appears on the vendor homepage. If you use an account that's detailed in the Accounts Payable account, it will show up on the vendor homepage.
Additionally, you might want to check these articles that will guide you in creating a recurring transaction for journal entries and to get a report on all money paid to a vendor:
Return to this thread if you have further concerns about including JE in the transaction list on the vendor homepage. I'll be here to help you in any way I can.
I create a monthly GJ from the statement of a small card we use for misc purchases. If i use accounts payable as the line item, it requires additional steps by having to enter a bill, then a check to pay, its a waste of time when by adding lets say office supplies account or gas account then listing the vendor, would make it much simpler if the transaction would then be listed on the vendor page. Any way to make it work that way?
Thank you
Cathy
Hello caacton,
Welcome to the QuickBooks Community! Currently, that is the workflow for QuickBooks Payments. However, I understand where you are coming from and highly suggest submitting feedback to our Developers. I will join you in this as well.
Let me know if you have further questions. I will be happy 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