Examples of common expense categories are mortgage/rent, utilities, kids, pets, health, groceries, restaurants, cars, clothing, travel, insurance, and debt repayment. The next step is sorting your expenses in a meaningful way. Learn more → Suggestions for categorizing expenses in your template

It’s completely free to try for 30 days, and you keep all data imported during your trial.

Read: Getting your financial data into your spreadsheetsĪutomated workflow: Tiller can automatically update your spreadsheets with your daily spending, account balances, and other account balances from banks, credit cards, brokerages, and 21,000 other financial sources.

Then you can either cut and paste your transactions into your spreadsheet, or export a CSV file that you can then either import directly into your sheets or again cut and paste data. Manual workflow: Log into your bank website. There are a couple of ways to get your bank and credit card transactions into your spreadsheets: With those facts, you will uncover far more trends - knowledge that will help you to greatly improve your business efficiency.How to get transactions from your bank into your expense template

Anecdotally, you may notice that drinking mugs sell well in the autumn while bathing suits sell poorly, but nothing beats hard facts available at a glance. This will help you to identify periodic trends in your expense patterns.Ĭreate a comparable sales sheet, and integrate the two so that you can see how your various expenses pay off. Note official holidays and other important commercial days, such as Black Friday after Thanksgiving. Organize this list in an electronic spreadsheet or other accounting instrument so that you can view purchases by day of week, day of month, month, quarter and year. For instance, you may find that the grocery department of your shop is noticeably more expensive to run, or that a particular seller delivers high-quality merchandise at reliably low prices. By doing this you can sort the same information many different ways and coax out important clues about the context of your expenses. Use a spreadsheet or other accounting instrument to manage your list, so that you can manipulate the data quickly with minimal errors.Īppend to each entry in the master list any additional statistics relevant to that purchase, such as the shipping cost, quantity of items bought, date bought, date delivered, supplier’s name, price paid per unit, condition of merchandise, type of merchandise, and new or used status. Process new inventory as soon as it comes in.

It enables you to document and track your expenses. Make an electronic master list of all your merchandise procurement costs, going as far back in time as you reasonably can.

Monthly business expenses worksheet