Good morning.
Can you advise if the following can be done please.
I've copied from the email I received from my bank.
Can the accounts package provider write a report that will age the debt by invoice date in both summary and detailed format?
This is what is being asked by the bank
Hi Barry,
I think that we cannot provide a report in the exact format your bank is
asking for. The closest thing would be the Outstanding Invoices report
grouped by customer. Sorry
Hi,
Can you tell me how to do this then, please?
Hi Barry,
Here's the approach I think you will need to take:
Export the Outstanding Invoices report from Solar Accounts to a PDF file and open the PDF file
Create a new spreadsheet using Google Sheets or Microsoft Excel
Copy and paste the information from the PDF file to the Excel spreadsheet
Send the spreadsheet to your bank
If you are not sure of the layout of the spreadsheet, ask your bank to provide an sample report in the layout they would like to see.
