Hi, I need a simple custom spreadsheet from Sage 50 v14 with the sections below grouped out in date order, for a date range of say 11-12-22 to 10-01-23.
I have to produce this each month using a laborious Bank Reports > Export to Excel cut and paste method in which the cells are often in different formats and the total formulas do not work once I export to Excel:-
Customer receipts
Cash receipts
Invoice Profit Bank Payments (difficult as my old Sage 50 v14 lets me highlight the invoices I want for the months date range they were paid in but then says, 'No data was returned for this report')
Bank receipts
Cash receipts
Supplier payments
Corp Tax Payments
VAT payments
Is this something anyone knows how to design or can recommend a budget priced designer?
Regards, Andrew