![]() I don't want any particular month to be overproportionally impacted, I also don't want A/P to get clogged up with something that isn't due any time soon. However, some services and subscriptions only charge you once a year for the whole year. A/P is discounted from my "available spending cash" KPI. Take invoices and credit card charges for example. Not all transactions immediately take away money from your bank account. One of the key reasons I'm tracking my finances in the first place is to have an exact idea how much spending cash I actually have. 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 |