cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

customer transaction report

How 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
Best answer 01-18-2019

Accepted Solutions
Level 15

Re: customer transaction report

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."

View solution in original post

Level 15

Re: customer transaction report

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.

View solution in original post

4 Comments
Level 15

Re: customer transaction report

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."

View solution in original post

Level 1

Re: customer transaction report

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".

Level 15

Re: customer transaction report

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.

View solution in original post

Level 15

Re: customer transaction report

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.

Need to get in touch?

Contact us