Hi Ragicians!
I am using Ragic’s Accounting Lite template. Its Account Titles sheet has 4 grades, but I need 5 per the generally accepted practice around here. My idea to extend the functionality without disturbing too much hard-coded stuff (like the Balance Sheet or Income Statement) is as follows:
-
Create a table called Sub-Ledgers, with a Link field to Account Titles table.
-
Create a subtable (A7) under the Journal Entries table, mimicking the Voucher Detail subtable (A13). The fields are a Link field to Sub-Ledgers (A7), a Load field from Sub-Ledgers (B7), a free text field, two number fields called Debit (F7) and Credit (G7), another Load field from Sub-Ledgers, which is the Link field in 1 (H7), and a Load field from Sub-Ledgers called Ledger Code (I7).
-
Create a new sheet from the subtable A7, called Voucher Sub-Details.
-
Aggregate Voucher Sub-Detail records by Ledger Code to Voucher Detail. If I add two entries in A7, then F7 should be aggregated to F13, and G7 should be aggregated to G13.
I can’t finish the last step.
However, if anyone has a better idea, I’m all ears.