I have an excel workbook which manages the purchase ledger side of the organisation. I would like several sheets to be consolidated.
Sheet itemized expenses is the main data entry sheet where all the expenses are entered.
From the itemized expenses sheet all data is automatically populated to Periodic summary, YTD SUMMARY and trial balance.
To set up a routine which should populate remittance sheet automatically by entering remittance number (this will be entered in the itemized expenses). Remittance template is included in the workbook for your reference and details the items required to be populated.
Supplier Statement: stating all the over due invoices and by aged summary on in row 17.
Monthly supply and payment summary.
Creditor age analysis required (sample sheet added for your reference)
Balance by each supplier (sheet added for your reference)
Please note that I would like the workbook to be versatile as I will be adding more Accounts title.
Let me know your comments and how the developer would like to commence.
This job was posted from a mobile device, so please pardon any typos or any missing details.
January 30, 2018
I am willing to pay higher rates for the most experienced freelancers