So if you're comfortable with double-entry bookkeeping, it's not as overkill as you might think. I see what you mean, but technically accruals just require another set of expense and liability accounts. Maintain one source in a datatable and let Excel functionality do the rest. using a pivot table, that pulls the data and automatically separates your months into columns etc. Then from that data, you can create a second sheet, e.g. Each posting should have a date, amount, description and an account (in double-entry bookkeeping you would use two accounts, debit and credit). This one I would recommend regardless of your skill level with accounting or Excel: Make one table with the raw data and then draw whatever summary or analysis you need from that and put it on another sheet.Admittedly, this will probably be too complex if you don't have any knowledge or interest in accounting, but if you do, it will give you much greater flexibility on what you can do with your personal finances (e.g., different current asset accounts for different budgets, making accruals, keeping tabs on accounts payables/receivables etc.)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |