![]() ![]() Checkbook for Excel - Checkbook for Excel is a full featured software application written for Microsoft Excel and is completely compatible with Excel 97/2000/XP.A history of the transactions is needed, along with a report towards the end of the year indicating how much is left to spend. Example: A college department secretary may need to keep track of the current account balance as a professor gradually depletes her grant money. ![]() When is this Excel Check Register Useful?Īnswer: When all you need is to keep track of the current balance in one or more accounts. If you want the ability to import transactions downloaded from a bank and other more advanced features, you may want to try software like Quicken or YNAB. There are certainly ways of expanding upon this template, but if you are planning to use Excel to keep track of your personal finances, I would consider using our new Money Management spreadsheet. When you want to analyze your expenses by category or create a budget report, that is when you need to make the switch to a more advanced template. Report Date: The date the general ledger was created or updated.Dynamic Drop-Down Lists for Dates and Check Numbers When the Excel Checkbook Is Not Enough.Post Reference: The location or subledger name where each transaction was recorded, sometimes called a PR or journal reference.Item Details: A description of the line-item debit or credit figure.Item Date: The date the line-item debit or credit figure was entered into the general ledger.Debit: The increase in assets or the decrease in liabilities for each transaction line item, also called a DR. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |