ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Free Accounting and Bookkeeping Excel Spreadsheet Template

Updated on September 17, 2013

Budgeting Tips for Easier Bookkeeping


Credits: Personal Income, Dividends, and More

Credits are considered the cash flow that comes into your home or business. The funds usually come in the form of employment income. However, there are several types of credits including dividends from investments, child support or alimony payments, windfalls and gifts, extra income by way of a second job, selling personal items, or inheritances.

Add up your credits so you know what you are able to save and spend in a single month. As a general rule, if you come across a windfall like a winning lottery ticket, or a cash gift, save one third, pay extra on your debts with one third, and feel free to spend the final third on something special for yourself or a family member.

Debits: Household Bills, Debt, Spending, and More

Your debits are much more than you realize. Your living expenses and debts are not the only thing you need money for. It’s important to budget items such as annual vehicle registration, new or replacement work attire, vehicle maintenance, and entertainment costs. Add up and prioritize your debits.

  • Pay yourself first. This means to deposit the allotted amount of income into your savings account, investment account, or put the cash under your mattress.
  • Pay your friends and family if you have a payment arrangement with them. Personal loans and mortgage holding are examples of reasons you would need to make payments to them.


How do you keep track of your finances?

See results
  • Your household bills are your next priority. Your rent or mortgage is usually the largest expense, and above all you need a place to live. If at all possible, occasionally make an extra mortgage payment to reduce the amount of interest you will be paying in the end. Make sure there is no pre-payment penalties before you do so.
  • Food is a necessity, so obviously that expense is a high priority item.
  • If a car payment is necessary to keep yourself accessible to transportation, by all means, pay that bill next. In most cases, you need transportation to get to and from work.
  • Insurance ownership is required by law in most states, so be sure there are funds for that expense.
  • Believe it or not, things like electricity, internet capability, cable TV, and cell phones are luxuries. Under certain circumstances, as in medical concerns, electricity and cell phones may need to be moved up on the list of priorities.
  • Other debts, loans, and credit cards should be last on your list of priorities. However the wise person will stay out of debt as much as possible. When in debt, try to pay as much as you can, and always pay at least twice the minimum payment to reduce the amount of interest you will end up paying in the end.

Free Accounting Template

This Balance Sheet was done in Excel.  Each month, add a new tab and change as needed.  I recommend you open a brand new spreadsheet for each year.
This Balance Sheet was done in Excel. Each month, add a new tab and change as needed. I recommend you open a brand new spreadsheet for each year. | Source

How to Balance Your Budget and Save

The key to balancing a budget is to reduce unnecessary spending of the credits in order to be sure there are enough funds to pay the debits. It is really quite amazing the amount of opportunities you have to cut spending for the purpose of saving money.

Check into insurance discounts. Some companies give multiple car or policy discounts. Some companies give Military discounts. Some companies give discounts to Automobile Association of America (AAA) members. Many companies also give discounts for safety equipment on vehicles. You may want to reduce your insurance premiums by increasing your deductible or lower your coverage if need be.

Cutting back on Cable TV is another way to reduce spending. Is it really necessary to have a package with hundreds of channels?

Groceries can be much more inexpensive if you watch the sales each store has in their weekly flyers. Coupons are a great way to save, as well. There are several coupon apps for smart phones and many online websites that offer printable coupons. Buying store brands in many cases will save you a bundle compared to always buying name brand items. If possible, buy in bulk when you find a great sale on non-perishable items.

Save on your electric bill in the summer by setting your thermostat just above your completely comfortable temperature and utilize fans for circulation. In the winter, wear socks, sweat pants, and long sleeves to stay warm. Keep lots of blankets handy as well. Be sure your home has great weather stripping around all windows and doors so that the cool or warm air doesn’t escape.

Subscriptions can be cancelled also. Small amounts add up, so if you aren’t enjoying that monthly magazine, cancel the subscription. There are many credit card companies that offer great “clubs” to be in for a small fee. Eliminate those small fees and save a bundle.

Thank you so much for reading my hub, and I hope the read was helpful and entertaining. Please leave a comment, suggestion, or constructive criticism in the comments section below. I would greatly appreciate your input.

"Be kind to one another" ~ Ellen

God Bless You ~ Margaret Sullivan


    0 of 8192 characters used
    Post Comment
    • Marcy Goodfleisch profile image

      Marcy Goodfleisch 

      8 years ago from Planet Earth

      Your points about cutting back on some extras are so true - I was able to reduce my cellphone bill by nearly half when I cut out things I didn't need or use that often. Great information and tips! Voted up and up!

    • teaches12345 profile image

      Dianna Mendez 

      8 years ago

      All good and so useful information on budgeting and accounting spreadsheets. I could use this as a refresher course.


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
    ClickscoThis is a data management platform studying reader behavior (Privacy Policy)