Reporting

Hi kkkkkkkkkkk,

A memo on a payment will actually show up on the ledger report, as shown in the screenshot below. However, it'll only appear to payments posted to a bank account or to Undeposited Funds, not under the A/R.

Alternatively, you can send out a Balance Forward type of Statement. This will show also show up the memo of a payment.

Let me know if you have additional questions about your report.

HOW TO GENERATE BALANCE FORWARD STATEMENT.

WHY DOES QUICK BOOKS DON'T ALLOW PAYMENT DES/MEMO IN THE LEDGER OF THE REPORT ?

WHAT IS YOUR JUSTIFICATION AS ITS VERY BASIC AND IN MOST OF THE SOFTWARE WE SEE THIS. SO IF I HAVE AROUND 1000 ENTRIES WHAT SHOULD I DO ?

 LIKE IF WE WANT TO MATCH OUR LEDGERS AND SEE THIS PAYMENT WAS AGAINST WHICH INVOICE SO HOW WILL I BE ABLE TO KNOW WHEN YOU GUYS DONT ALLOW US TO SEE IT A LEDGER FORM.

PLEASE PROVIDE ME WITH A SOLUTION AS THIS IS VERY BASIC AND CAN BE SEEN IN MOST OF THE SOFTWARES. THIS IS THE ISSUE I AM ALSO SHARING  A SCREENSHOT AS WELL. THIS IS THE REPORT I WANT AND WANT DESCRIPTION IN THIS REPORT. IF YOU KNOW ANY OTHER SIMILAR REPORTING THEN LET ME KNOW WHERE I CAN SEE PAYMENT DESCRIPTION.

I can walk you through in creating customer statements, kkkkkkkkkkk.

The note you entered in the Memo field of the Receive Payment description will post in your General Ledger report. Another way to look into the payments and invoice it was linked to is by opening the Balance Forward customer statement type. It lists invoices and payments with balance for the date range you selected. Here's how to create one:

1. Go to the +New button and click Statements. 
2. In the Statement Type drop-down, click Balance Forward. 
3. Fill in the date fields and select Apply.
4. Click the customer you want to make statements for.
5. Select Print or Preview on how it looks like. 

To look into the customer statements and ledger, you can open a new tab and pull up the report from there. 

For more details, check out these references on how to create statements and customise financial reports. 

Let me know if you need anything else. You take care and have a great day!

Like Statement Report for customers. Is there a similar report for Vendors as well ?

Similarly about General I cant customize it to a specific customer and vendor please provide a step by step solution for that as well.

Thankyou

Hi, kkkkkkkkkkk.

You can pull up and run the Transaction List by Vendor/Supplier report since statements for vendors is currently unavailable in QuickBooks Online.

Here's how to run the report:

1. Click Reports in the left panel and search for Transaction List by Supplier.
   
   
2. From the report screen, click Customise.
   
   
3. Go to the Filter section, tick the supplier you'll want to display on the report.
   
   
4. Within the Rows/Columns section, add the Open Balance.
5. Hit Run report.
   

To get more ideas on how to customise and utilise your reports in QuickBooks Online, you can visit the following article: Customise reports in QuickBooks Online. Also, this will provide you a link on how to manage and share your custom reports.

You can always get back to me if you need additional assistance. I'd be more than willing to lend you a hand.

The reason why I cant use this report is it doesnot show proper running balance. Please suggest a different report for my vendors.

Thankyou

Hi kkkkkkkkkkk You can run a Purchases by supplier report, you'll be able to customise  > filter this by a specific supplier and it'll give you a running balance and total

Purchases by supplier report does not show Payment entries to supplier.

I need a report that shows both payments and bills narrations and proper running balances.

Hello Kkkkkkk, 

You could run the Purchase by Product/Service details and custominse the report so ti just shows you want you are wanting to see.