Hi,
I think I've cracked it. I have created a detailed DSoFA that I drop into Excel and then use meta data to group codes into our reported DSoFA summarised into our SoFA. The bottom line is checked against Xero's Current Earnings to ensure nothing's been missed.
At the end of the year, codes in the unused 100 range of codes are used to account for movements into/out of/between funds with an opposite balance that matches Current Earnings.
The Balance Sheet handles Funds through specific equity codes receiving the transactions in the 100 range. there is a balancing entry that matches retained earnings.
I have attached an file with a downloaded DSoFA, a Balance Sheet and just because I have it a three year management account report.
We use tracking to control projects and to allow us to report on our activities for grant bids.
Hi,
I think I've cracked it. I have created a detailed DSoFA that I drop into Excel and then use meta data to group codes into our reported DSoFA summarised into our SoFA. The bottom line is checked against Xero's Current Earnings to ensure nothing's been missed.
At the end of the year, codes in the unused 100 range of codes are used to account for movements into/out of/between funds with an opposite balance that matches Current Earnings.
The Balance Sheet handles Funds through specific equity codes receiving the transactions in the 100 range. there is a balancing entry that matches retained earnings.
I have attached an file with a downloaded DSoFA, a Balance Sheet and just because I have it a three year management account report.
We use tracking to control projects and to allow us to report on our activities for grant bids.
Happy to talk further.