Personal Budget (bi-monthly paychecks)

7 0

This template allows you to create a budget and see exactly where your money is going. You can see average spending, estimated costs, yearly &monthly expenses, etc

Project Description

There are a total of 19 sheets in this template:

• Monthly Expenses

• This is where you create your budget. Simply input your yearly income into B3; 401k % into C15; and the cost of your individual benefits into the respective row in column B; and your paycheck will be calculated, taking benefit cost and taxes into consideration.

NOTE*: Taxes and FICA will be at $0 & 0% until the Tax % Check sheet has at least one paycheck entry.

 

• Tax % Check

• This sheet is used to keep track of your tax %'s being taken out from your pay check as well as to keep track of your pay.

• Place the Date of the check in the Date row; amount of the check (after benefits are taken out, but before taxes) into the CHECK row; then the Federal, State, SS, Medicare in the respective rows.

• The total amount of all entries will be shown on the top of the page in the Tax % Check (to date) table.

 

• Yearly Expenses

• This page is completely automated. All entries will be updated to reflect estimated yearly expenses from monthly expenses.

 

• Actual Spent-to-Date

• This page shows actual spending habits, average spending, and "amount of bills per paycheck" (in respect to your estimated budget)

• The "Selection List" (A14) is a drop down list that allows you to view common expenses and see the average of those expenses.

• The Selection List gets it's elements from a hidden page called Expense Names. To edit the elements, simply go to this sheet.

NOTE: 'Bill' elements are rows 1-11, all other expenses can be modified and added up until row 35.

NOTE: You CAN type in anything into this, but if it is not uniform (case sensitive), you will not get an accurate average for that expense.

 

• Jan - Dec

• These sheets are where you would put your daily/monthly transactions (bills, food/misc, other, savings [in and out], etc)

• To start, make sure to put your check amounts in the "Check 1" "Check 2" (E2, F2) boxes.

• I would recommend for the name column of each expense, to be general, and in the description to get more specific so that the averaging tool on "Actual Spent-to-Date" would be more accurate.

 

• Non-monthly Expenses

• Use this sheet to put in expenses that are large and that you don't want to show up on your month to month budget; in your Jan - Dec sheets.

 

• HSA Expenses

• This one may or may not be applicable to everyone. This sheet is used to keep track of expenses from your HSA (Health Savings Account) account. Initial amount at beginning of year, employer contributions, spent, approximate current.

• Your monthly amount is calculated automatically as long as you put in your monthly amount into the Benefits section on the Monthly Expenses sheet.

 

 

I believe that covers everything! I hope this helps you in your budgeting endeavors!

Category/Categories

Calendar, Grocery, Budget,

Current Release

No stable release available yet.

Latest Not Stable Release

Personal Budget (bi-monthly paychecks) - 1.1

tested with:

LibreOffice 6.2,

Personal Budget.ots
Mac OS X
File size: 45 kb

All Releases

Template Version

Platform(s)

Compatibility

Description

License(s)

Status

Personal Budget (bi-monthly paychecks) - 1.1

  • Mac OS X
  • LibreOffice 6.2
- Added chart on 'Actual Spent-to-Date' to show percentage of income spent on each expense type.
  • GNU-GPL-v3+ (General Public License Version 3 and later)
beta

Personal Budget (bi-monthly paychecks) - 1.0

  • Linux-x64
  • Mac OS X
  • LibreOffice 6.2
Initial Release
  • GNU-GPL-v3+ (General Public License Version 3 and later)
alpha

Legal Disclaimer and Limitations for Downloads

The Document Foundation has not reviewed, and cannot review, all of the material, including computer software, available on or by means of The Document Foundation's
websites, and cannot therefore be responsible for that material's content, use or effects. By operating its websites, The Document Foundation does not represent or imply that it endorses the material there available, or that it believes such material to be accurate, useful or nonharmful. You are responsible for taking precautions as necessary to protect yourself and your computer systems from viruses, worms, Trojan horses and other harmful or destructive content. The Document Foundation's websites may contain content that is offensive, indecent or otherwise objectionable, as well as content containing technical inaccuracies, typographical mistakes and other errors. The Document Foundation's websites may also contain material that violates the privacy or publicity rights, or infringes the proprietary rights, of third parties, or the downloading, copying or use of which is subject to additional terms and conditions, stated or unstated. The Document Foundation disclaims any responsibility for any harm resulting from the use by The Document Foundation's visitors of The Document Foundation's websites, or from any downloading by those visitors of content available on or by means of The Document Foundation's websites.

Changes

Content contained on The Document Foundation's websites, including these Legal Disclaimers and Limitations, may be changed at the sole discretion of The Document Foundation and without notice. You are bound by any such updates or changes, and so should periodically review these Legal Disclaimers and Limitations.

If you believe any file is present on the site contrary to any TDF rule or applicable law, please supply full details to info@documentfoundation.org for impartial consideration.