primuspaul
Board Regular
- Joined
- Dec 23, 2015
- Messages
- 75
- Office Version
- 2021
- 2019
- Platform
- Windows
I have data that comes in as individual accounts (could be 100-200 accounts) along with an amount next to it (two columns).
Account name......Amount
Account name......Amount
Account name......Amount
Account name......Amount
I need an automated way of generating financial statements using that data. They should look something like this:
https://www.aicpa.org/InterestAreas...forSMEs_SampleFinancialStatements_FSUsers.xls
Unfortunately, the statements aren't really "logical" as far as a computer is concerned. Each account on the account chart could belong to one type of statement and not to another, or perhaps to multiple statements. In each statement, the accounts would NOT appear using the account name found in the chart, but would be allocated to aggregate accounts. For example, TD Bank $10,000, Bank of America $11,000, and Petty Cash $1,000 on the account chart could appear on the balance sheet under the "ASSETS:" category as Current Assets $22,000.
I thought about using pivot tables and adding columns to the chart of accounts that had markers indicating the financial statement and aggregate category in said statement to which each account belongs, but it never comes out right. Many of the financial statements simply have illogical formats. I'm sure you can see that yourselves. Has anybody tackled this problem? Is there a working template available? What approach would I take to doing this the right way?
Account name......Amount
Account name......Amount
Account name......Amount
Account name......Amount
I need an automated way of generating financial statements using that data. They should look something like this:
https://www.aicpa.org/InterestAreas...forSMEs_SampleFinancialStatements_FSUsers.xls
Unfortunately, the statements aren't really "logical" as far as a computer is concerned. Each account on the account chart could belong to one type of statement and not to another, or perhaps to multiple statements. In each statement, the accounts would NOT appear using the account name found in the chart, but would be allocated to aggregate accounts. For example, TD Bank $10,000, Bank of America $11,000, and Petty Cash $1,000 on the account chart could appear on the balance sheet under the "ASSETS:" category as Current Assets $22,000.
I thought about using pivot tables and adding columns to the chart of accounts that had markers indicating the financial statement and aggregate category in said statement to which each account belongs, but it never comes out right. Many of the financial statements simply have illogical formats. I'm sure you can see that yourselves. Has anybody tackled this problem? Is there a working template available? What approach would I take to doing this the right way?
