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 do I get the source name to show on customer transaction reports? Do I need to ad something to customer setup? We do not use invoicing so the payment is received as a bank deposit and post received from but does not show up in the transaction by customer report.
??
Solved! Go to Solution.
Let's understand Perspective: if you use a Customer report, the"name" is Customer. Period.
A Source name comes from, for instance, Unbilled Costs by Job, where the Payee name is the Vendor (source) and on the Details you Job tracked the items, which makes the customers Target Names.
"We do not use invoicing so the payment is received as a bank deposit"
That is your Oversight. Use Sales Receipts.
Invoice = unpaid for the date of sale, I need to track that I am owed, the payment comes later, and it is its own Dated event as Receive Payment.
Sales Receipt = charges are also paid for this One Date. And now you have a Customer Name on a Customer Transaction for Sales reporting and tracking.
"and post received from but does not show up in the transaction by customer report."
Because you are "doing some Banking."
This is not unusual; it simply requires that you move forward using the Right functions for what you asked: "I did not set up the company file nor was I told until after the work was completed that a detailed customer transaction report was critical."
Because you cannot report what you did not track. It is likely they overlooked tons of functions and tools, as well as the great reporting.
"Hopefully this will reduce my time to redo then entire year of payments to "Sales Receipts"."
Glad to help.
Let's understand Perspective: if you use a Customer report, the"name" is Customer. Period.
A Source name comes from, for instance, Unbilled Costs by Job, where the Payee name is the Vendor (source) and on the Details you Job tracked the items, which makes the customers Target Names.
"We do not use invoicing so the payment is received as a bank deposit"
That is your Oversight. Use Sales Receipts.
Invoice = unpaid for the date of sale, I need to track that I am owed, the payment comes later, and it is its own Dated event as Receive Payment.
Sales Receipt = charges are also paid for this One Date. And now you have a Customer Name on a Customer Transaction for Sales reporting and tracking.
"and post received from but does not show up in the transaction by customer report."
Because you are "doing some Banking."
Thanks for the reply and assistance.
I did not set up the company file nor was I told until after the work was completed that a detailed customer transaction report was critical. Hopefully this will reduce my time to redo then entire year of payments to "Sales Receipts".
This is not unusual; it simply requires that you move forward using the Right functions for what you asked: "I did not set up the company file nor was I told until after the work was completed that a detailed customer transaction report was critical."
Because you cannot report what you did not track. It is likely they overlooked tons of functions and tools, as well as the great reporting.
"Hopefully this will reduce my time to redo then entire year of payments to "Sales Receipts"."
Glad to help.
Oh, here is the Fastest way to Fix this file:
Using Sales Receipt allows you list actual Products, or Services as charges, or even Noninventory Items and Other Charge Items. For this Historic sales, you obviously didno't manage this as inventory using QB, because you "did some banking."
Let's make one Noninventory Charge item linked to the Income account you used manually for Sales as Deposit. List this on each Sales Receipt, where you don't even need a Customer name at all, for each "DEP" that manually posts as income, for each date and amount, for each name if you need this much detail, etc. Parallel manual DEP as Income using actual Customer and Sales info. Make sure they flow to Undeposited Funds.
When you are ready, open any existing DEP transaction and use the button at the top for Payments. This forces the Pop Up and here are the Replacement Transactions. Select from here those sales receipt(s) that you know comprise this Deposit. Then click on and Delete your existing Manual Line entry that is Income.
Think of the DEP as an Envelope. You just opened one, and traded the contents to the Meaningful contents. This should be the Same Amount, bottom right.
Save and Close.
This will not even Unreconcile.
Now you have Sales and Customer info.
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.