There is a deposit slip log, and there is a cheque log.

Other than that, you could just run a G/L report for the account, but it would include loan proceeds and payments, remittances, etc.

Which version (year) and Edition of Sage 50 are you using?  (pro, prem, Quantum)   Have you looked at XLGL?

I am using 2014 Sage 50 Pro. I haven't looked at XLGL, no.

I did check the G/L and it appears to be showing everything correctly. How can I access the XLGL? For future.

You could run the gl report for the AR and AP accounts, export to excel and then eliminate the invoices - isolating only the payment amounts.

XLGL is an add-on reporting tool program for Sage 50 and Excel, available from Logicim  (www.logicimtech.com)

If you don't have it, and you want an EXACT list of only payments and receipts (regardless of payment method) :

 (Amygurl's suggestion will also show all credit notes and returns)

Run a detail report of A/R showing prior payments, and export to Excel.   If you only want a specific range in the report (i.e. September) select 'As At'  Sept 30, and 'include invoices paid in the last [ 30 ] days'.

Run a detail report of A/P aging, and export to Excel.

On each sheet:  

- Delete the top three rows, so there is only the column title row.

- select the entire sheet, and create an 'autofilter'.  (AutoFilter is a little different in each Excel version)

- Then, click on the drop-down for the description column,

- deselect all, and select payment, and click 'OK'.

- Select the 'date' column, and check of the date range you need.

- Select (Click on bar above) the 'total' column, and you'll see the sum at the bottom of the Excel window.

You can also copy, and paste the filtered results into another sheet.  

If you're going to want to show both payments, and receipts mixed together in one sheet, you could do a search-and-replace in the Receivables Aging to change 'payment' to 'receipt', or move all the 'receivable' payments to a separate column

*************************************************************************************************

Whether you want to look at getting a custom reporting tool like 'XLGL', or Sage 'Intelligence', depends a lot on how many custom reports you need to do, and how often.  

I used to put together an Excel Project report with each project in its own column.  It took hours, and since I bought XLGL it takes a couple of minutes.  I'm careful to never show it unless three hours have gone by since it was requested.  

I'm not an XLGL 'Guru', but I'm sure that a report like this could be built in at most a couple of hours, and then called up and printed in a minute or two each time you need it.

Thank you very much for your help. I will be sure to do this, I really appreciate your time to help me with this.