![]() OP’s workbook is currently setup for each month containing its own tab, and eventually putting all of the data in an ever growing “raw data” will eventually become untenable. Just conservatively estimate the amount, divide it by 12, and book it in the accruals when the paycheck arrives.īut of course, accruals aren't the only way to deal with these problems, especially since your personal finance spreadsheet doesn't have to comply with any accounting standard. They invoice you once a year, and while that amount can be perfectly anticipated and saved up for, most people are taken by suprise when the bill arrives. Also, where I'm from, taxes are not taken out of your salary automatically. 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).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |