How to Get Reports on Payable and Receivable.

Question

Hi There, 
 My company just started using sage 50 pro a couple of weeks ago and I am trying to set up the reports for the book keeper to show the invoices paid in a single report for both payable and receivable. I have tried several options in Sage to get the reports to work but it keeps coming back with no data or only a small sum from debit but nothing from any other payment methods. How can I fix this? 
 
 Thank you for your time and assistance in advance.

RandyW · Accepted Answer

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?

RandyW · Answer

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.

Sage 50 Canada

How to Get Reports on Payable and Receivable.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING