EXCEL TEMPLATE TO TRACK EXPENSES HOW TO
EXCEL TEMPLATE TO TRACK EXPENSES FREE

Each time a new bill is entered, put the hard copy and proof of payment in a binder.In the event of a payment dispute, the Medical Bill Tracker Excel Template affords a fast, easy way to track the payment, though you will still have to provide the receipt. Back up all of your data electronically and on paper.

Tips for Using the Medical Bill Tracker Excel Template If so, call the doctor using the more expensive lab and see if another arrangement can be made. For example, you may find one doctor is submitting blood work to a lab that charges you less than another doctor’s lab. Look for things like duplicate billing numbers, multiple parties submitting billing for the same thing and so on.

Third, use the column tabs to sort the data as you desire.

The template is customizable allowing for multiple insurance company payouts to be tracked.

Second, enter the data into the fields provided.

EXCEL TEMPLATE TO TRACK EXPENSES HOW TO

How to Use the Medical Bill Tracker Excel Template The template provides an easy to use, customizable tool that makes quick sense out of a stack of bills. Lastly, it creates a money saving resource over time. Secondly, because there are so many involved from insurance companies to labs, therapists, doctors, hospitals and so forth, sometimes things get double billed. Why Use the Medical Bill Tracker Excel Template?įirst and foremost, medical bills are expensive and can ruin your credit.

EXCEL TEMPLATE TO TRACK EXPENSES FREE

Use the free downloadable Medical Bill Tracker Excel Template to get a handle on the situation. What used to be a trip to one doctor now involves many people each submitting separate billing. Here, you can see the Grand Total for this Year in big bold text as well as the breakdown of the total costs by area or category.Ī Cost Pie Chart is also created, which automatically updates as you fill out your lawn and garden expense template.Modern medicine is so advanced. All these are then collated into one Summary Table, on the top right portion of the template. You can also record here the Quantity, Cost/Item, and Cost/Year.Īll the costs are automatically calculated to give you an accurate total in each table. And to help you rotate your crops, you can schedule when to plant each crop, tree or seedling. This also allows you to list your supplier for reference. This contains a list of all the plants, trees, shrubs, and seedlings that you have planted in your garden.

The third table is for Garden Plants and Seeding Plan. Here, the columns are divided into Item, Company or Service, Times/Month, and Cost/Year. The table for Garden Care is divided into Lawn Care, Plant and Bed Care, and Shrubs and Tree Care. Each of these major garden expense categories are divided into different color-coded tables.Įach expense item that go into Gardening Equipment table is recorded according to Item, Maker or Supplier, Quantity, Cost/Tool, and Cost/Year. The template is very comprehensive, allowing you to group together your expenses for gardening equipment, garden care, garden plants and seeding plans, and many more. This free Excel template makes it easy for you to categorize your expenses as well as keep track of your yearly costs. The Lawn & Garden Expense Template for Excel is a colorful template for lawn and garden expense tracking and recording.

Excel template to track expenses