The Pet Accountant Bookkeeping Spreadsheet

Easy to complete, informative and an allowable business expense!

Bookkeeping Spreadsheet 2024/2025

Setting Up Your Spreadsheet

Our spreadsheet is built in Microsoft Excel so in order to start using it you will need a device capable of opening and editing a Microsoft Excel file. 

Upon opening the file you can begin customising it to your business. Simply click into the light blue highlighted cells and complete the following;

The terminology is based on what your business does. So for a groomer would would select groom, or a dog walker would select walk. This will change the way metrics are displayed personalising your experience. 

The little red triangle in the cell means there are help notes available. Simply hover the mouse curser over the little red triangle for a helpful note to appear. 

Bookkeeping Spreadsheet Set Up

Lower That Tax Bill!

With a tab dedicated to explaining what you can claim for and what category they should be classed as you will be lowering that tax bill sooner than you think. 

With headings such as Drawings and Salaries & Wages, you get a brief explanation of what it is so you can correctly classify the expense. The spreadsheet will then automatically calculate if its an expense or if it just affects your cash flow. 

Completing Your Monthly Sections

Each month is conveniently split into its own tab accessed at the bottom of the screen in dark blue. 

At the top of each page, you will receive useful insights into your business performance as the month develops. 

Recoding Your Sales

Starting from the left of the screen simply enter the date, the customer or reference you want to use and the amount. Then under the Cash, Card or Bank Transfer column, re-enter the amount to display how that customer paid. 

Recording Your Expenses

Located in the grey section in the middle of the screen you simply complete the fields starting with the date, the supplier name, an invoice or receipt number (don’t worry if you can’t find this but it would be helpful if HMRC wants to see things later down the line) then a description of what you bought. This is just a brief description such as Poo Bags or Shampoo. 

Next, complete the amount you paid for the expense (if you paid cash for it rather than from your business bank account you will need to enter the cash amount for the month at a later stage). Finally, select the category for the expense from the drop-down list.

Other Money In Or Out 

Unlike an expense this column is used to record things like money you take out of the business or money you put in, any loan repayments (as they are not an expense) or any other things in and out of your bank account. If you can’t find the reason in the expense section – try finding something in the drop-down list on this side. 

Spreadsheet Help
Cashflow

Recording Cash Purchases

Add your cash purchases to the expense column as normal. But at the end of the month add up all the money you spent as cash and add it to the cashflow tracker on the profit and loss tab. This is the only cell you can edit on this screen titled Value Of Items You Paid Cash For.

This will ensure the bank balance tracker will remain correct and as long as you put every transaction from your bank statements into this tracker it will match your bank balance at the end of the month. (But you must make sure 100% of transactions are included even if they are personal.)

Useful Metrics At Your Fingertips

As you enter your monthly incoming and outgoings the spreadsheet will start to calculate various metrics to help you understand your business finances.

You can use the metrics to make business decisions such as changing your pricing to increase profits, or assessing specific category spending month by month to see if you are paying too much in a specific area.