How to Do Small Business Bookkeeping in Excel: 5 Key Tips (2024)

How much will you pay in Stripe transaction fees?

Calculating Stripe fees for customer payments is easy with our calculator. Enter the payment amount to calculate Stripe's transaction fees and what you should charge to receive the full amount.

Payment Amount

Calculate

Our calculations are based on Stripe's per-transaction fees of 2.9% plus $0.30.

Stripe fee:

$ --

You'll receive:

$ --

To take home $--, you should ask for:

$ --

How much will you pay in Square fees?

Calculate how much you’ll pay in Square fees for online, in-person, and manually-entered payments.

Payment Amount

Calculate

Square fees

Amount received after fees

In-person payments

i

For in-person payments with a card, Square charges a fee of 2.6% + $0.10 per transaction.

$ --

$ --

Manually-entered payments

i

For manually-entered payments or card-on-file payments, Square charges a fee of 3.5% + $0.15 per transaction.

$ --

$ --

Online payments

i

For online payments or payments via invoice, Square charges a fee of 2.9% + $0.30 per transaction. (If you're signed up for the Premium plan, the percentage fee is lower at 2.6%.)

$ --

$ --

Calculate estimated loan payments in seconds

Enter your loan information to get an estimated breakdown of how much you'll pay over the lifetime of your loan.

Loan Amount

Loan Term

Months

Years

Loan APR

Calculate

If you borrow -- over -- at an interest rate of --, you will pay a total amount of --, or -- per month.

Minimum monthly payment:

$ 0.00

Average monthly interest:

$ 0.00

Total interest paid:

$ 0.00

Total amount paid:

$ 0.00

How much will you pay in PayPal fees?

PayPal fees can be confusing. Our calculator helps you understand how much you’ll pay in fees for common transaction methods.

Payment Amount

Is the payment domestic or international?

Domestic

International

PayPal fee rate

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Calculate

PayPal fee:

$ 0.00

You’ll receive:

$ 0.00

To take home --, ask for:

$ 0.00

anaging your day-to-day finances is one of the most important tasks of any small business. Bookkeeping is the process of recording daily business transactions. Having a good system for bookkeeping will help keep your business finances organized year-round.

Some businesses choose to hire a bookkeeper or utilize accounting software for their bookkeeping. If you’re already a small business owner or just starting your own business, you can save money by using Excel to create a bookkeeping system. Chances are you already have access to the computer program. Learn how to do small business bookkeeping in Excel like a professional, and get access to our free Google Sheets and Excel bookkeeping template for small businesses.

Why use Excel for your small business bookkeeping

Microsoft Excel has been around for decades but is still used by businesses today because of its accessibility and robustness. Excel has a number of useful applications, including bookkeeping. Here are a few reasons you might want to do your small business bookkeeping in an Excel spreadsheet:

  • You probably already have it installed on your computer. If not, it’s available to download for a small fee. You can also use Google Sheets, a similar program powered by Google that is completely free to use.
  • Using Excel is likely cheaper than hiring a bookkeeper or investing in popular accounting software programs.
  • Excel has several helpful features and functions that can help you create a small business bookkeeping system that works. You can enter and categorize transactions through Excel, create various bookkeeping templates, track invoices, and much more.
  • Training on using Excel is also readily available online (often free of charge) to get you and your employees up to speed if required.

How to create a small business bookkeeping system in Excel

To create a bookkeeping system for your business, you can start with a blank Excel spreadsheet or use our spreadsheet template. Depending on your experience level, using a template may be an easier way to get started. Use the following steps to set up your bookkeeping system in Excel.

1. Keep your business and personal finances separate

Before you set up your bookkeeping spreadsheet, an essential first step is to ensure you can isolate your business transactions with ease. The easiest way to do so is to keep your business and personal finances separate with a business checking account. If you keep all of your finances in the same account and commingle business and personal funds, you risk making your finances very confusing. It can be hard to differentiate which transactions are personal and which are for your business, which can make bookkeeping difficult and create undue stress and confusion during tax time.

With a separate business account, you can easily track your business cash flow. This will help you claim tax deductions, protect your assets from liability, and gain access to certain funds that are business-only. Having a business checking account will also legitimize your business with your customers.

Novo offers one of the most popular business checking accounts for small businesses. With no hidden fees, no minimum balance requirements, a free invoicing tool, and dozens of business software integrations, Novo is built to help your business thrive.

Learn more about Novo business checking and why it’s the preferred platform for more than 200,000 businesses.

2. Decide what accounting method you want to use

There are two primary accounting methods that businesses use — cash accounting and accrual accounting. The difference lies in when you record company revenue and expenses. With cash accounting, you record revenue and expenses when money is received or paid. Accrual accounting records revenues and expenses when they are earned or incurred.

Cash accounting gives you a narrower, less accurate picture of your business finances than accrual accounting does, since you’re not tracking income and expenses as they occur. Additionally, not all businesses are permitted to use cash accounting – namely, businesses with more than $25 million in annual sales. That said, it’s preferred by some small businesses due to its simplicity.

Accrual accounting gives you a more accurate financial picture and conforms with GAAP (Generally Accepted Accounting) principles. And while you may not be making more than $25 million annually now, the accrual accounting method is set up to grow as your business grows. However, it requires more resources than cash-basis accounting and doesn’t give you a picture of how much money you actually have in your bank account at a given moment. If you adopt the accrual accounting method, it’s important to be extremely meticulous in your bookkeeping practices.

3. Create a chart of accounts

The first essential spreadsheet in your bookkeeping system is the Chart of Accounts (COA). This is a comprehensive list of all accounts used in your financial tracking. Each account serves as a specific category that transactions are assigned to, enabling thorough and organized financial monitoring.

While a template may come pre-populated with some standard accounts, you should customize any COA template to fit your unique business needs. Each account listed in the COA should include an account type (income, expense, etc.), an account name, a unique number for easy identification, and an optional brief description to aid in the correct allocation of transactions. The COA is a dynamic tool that can be updated and modified as your business evolves and its financial complexity grows.

4. Create an income and expense sheet

Next, you’ll need to create an income and expense sheet. These can either be set up as separate sheets (or tabs on the same spreadsheet) or set up in one comprehensive sheet. As transaction receipts come in, record them on this sheet.

Receipts typically come in paper or electronic form. It’s a good idea to create filing systems for both. For paper receipts, either keep them filed (either by date or alphabetically) or snap a photo of them and store them electronically with your other e-receipts. Find a system that works best for you and stick with it.

Keeping accurate records is the key to a good bookkeeping system, and this sheet is imperative for reaching that goal.

5. Create optional bookkeeping reports

Depending on your type of business, you may want to take your bookkeeping a step further by creating some extra Excel spreadsheets to help you assess your company’s financial health. Dozens of business reports exist, but here are three reports you should consider adding to your Excel bookkeeping system first.

  • Income statement sheet: Also known as a , this report shows company profitability over a period of time. The report is broken down into different aspects of your business and allows you to see which ones are the most or least profitable.
  • Balance sheet: Consider a balance sheet as an overview of business assets, liabilities, and equity over a period of time. Our Excel bookkeeping template includes a balance sheet template.
  • Cash flow statement sheet: A cash flow statement lets you know how much cash you received over a period of time. While your income statement relies on accrual accounting, this statement reports actual cash flow from paid invoices and expenses.

Depending on your business model, you may also want to add a sheet to track inventory or invoice payments. Our free bookkeeping template includes sheets for tracking both.

Download our Excel bookkeeping template

If you don’t want to start from scratch, here’s a free Excel bookkeeping template your business can utilize. It includes:

  • A Chart of Accounts
  • An income tracking sheet
  • An expense tracking sheet
  • An inventory tracking sheet
  • An invoice tracking sheet
  • A balance sheet

This bookkeeping template is in the form of a Google Sheet. To use it in Excel, navigate to File >> Download and select Microsoft Excel (.xlsx). Once downloaded, you will be able to open this template in Microsoft Excel.

Depending on the specifics of your business, you may need to customize this bookkeeping template to suit your business needs. This template serves as a starting point for setting up a bookkeeping system in Excel.

Download our bookkeeping template

How Novo can help with bookkeeping

One of the most important aspects of bookkeeping is the day-to-day recording, tracking, and reconciling of all of your business transactions. With Novo Business Banking, you can add details to every transaction, including categories, notes, images, documents. You can also export all of this data in a CSV file for easier bookkeeping in Excel.

Excel may or may not be the best program for generating these types of reports, so play around and see if it allows you to do what you need. Having a solid bookkeeping system in place and using it daily will help you manage your business more efficiently, give you a better sense of your company’s future, and save time.

Novo Platform Inc. strives to provide accurate information but cannot guarantee that this content is correct, complete, or up-to-date. This page is for informational purposes only and is not financial or legal advice nor an endorsem*nt of any third-party products or services. All products and services are presented without warranty. Novo Platform Inc. does not provide any financial or legal advice, and you should consult your own financial, legal, or tax advisors.

Novo is a fintech, not a bank. Deposit account services provided by Middlesex Federal Savings, F. A.; Member FDIC.

How to Do Small Business Bookkeeping in Excel: 5 Key Tips (2024)

FAQs

How to do small business bookkeeping in Excel? ›

Here's how you can create a bookkeeping system in Excel.
  1. Step 1 – Prepare a Bookkeeping Excel Sheet Template. ...
  2. Step 2 – Customize Your Chart of Accounts. ...
  3. Step 3 – Customize Your Income Statement Sheet. ...
  4. Step 4 – Create a Sheet for Invoices. ...
  5. Step 5 – Create a Sheet for Projecting Cash Flow. ...
  6. Step 6 – Save the Excel File.

What is the best bookkeeping method for small business? ›

Double-entry bookkeeping is the industry standard since it more accurately records and matches activity to every affected account. Most accounting software has options to work in both methods.

How do I set up manual bookkeeping for my small business? ›

Basic Tips on Getting Bookkeeping Right
  1. Create a New Business Account.
  2. Set Budget Aside for Tax Purposes.
  3. Always Keep Your Records Organised.
  4. Track Your Expenses.
  5. Maintain Daily Records.
  6. Leave an Audit Trail.
  7. Stay on Top of Your Accounts Receivable.
  8. Keep Tax Deadlines in Mind.

What is the simplest form of bookkeeping? ›

Single-entry bookkeeping is a simple and straightforward method of bookkeeping in which each transaction is recorded as a single-entry in a journal.

What is the golden rule of bookkeeping? ›

The three golden rules of accounting are (1) debit all expenses and losses, credit all incomes and gains, (2) debit the receiver, credit the giver, and (3) debit what comes in, credit what goes out.

How do I teach myself bookkeeping? ›

Use a Bookkeeping App: The best way to learn is to get hands-on in your own time and use a bookkeeping app that's both easy to use and understand. No formal degrees, no qualifications. Just look for one that has useful features you'll need and not packed full of ones you'll probably never use.

What is the hardest part of bookkeeping? ›

The Internal Impasse: Juggling Priorities and Deadlines

They might be responsible for accounts payable and receivable, payroll processing, bank reconciliations, and generating financial reports — all on top of handling client inquiries and staying updated on regulations. Time management becomes a critical skill.

How many hours does it take to do bookkeeping for small business? ›

The time needed for bookkeeping in a small restaurant can vary, but on average, it might take around 10 to 20 hours per month. This can depend on the size of the business, the complexity of financial transactions, and the efficiency of the bookkeeping process.

How to do single entry bookkeeping? ›

Single-entry accounting is a straightforward accounting approach where you can record each transaction as a single entry in a journal. You can begin by adding your existing cash balance and then add the income you receive, less your expenses, to determine your cash balance.

Can you do bookkeeping by yourself? ›

Being your own bookkeeper means you get to decide how things are done. This is a huge plus for business owners that have experience bookkeeping and know what they're doing. You also get to choose what software you feel most comfortable using — since some bookkeepers will only work with certain software.

How many hours a week is bookkeeping for a small business? ›

You can expect to work about 3 hours per week per client on their bookkeeping services. However, the total number of hours you work and the number of clients you need to reach different income levels will depend on the size of the client's business and the monthly retainer you charge them.

Does Excel have an accounting template? ›

If you open up Excel and then use the relevant keyword in the “Search All Templates” box, you should be able to find a basic template that will fit your needs. For example, Excel has an inbuilt profit and loss statement template, business expenses budget template, budget planner template, and more.

Do you need QuickBooks or can you use Excel? ›

Deciding between Excel and QuickBooks largely depends on your needs and preferences. Record-keeping is a vital part of your company's financial health. While you can choose Excel if your financials are not complex, modern tools like QuickBooks can significantly accelerate your business growth.

Top Articles
Pacific Paint (BOYSEN) Philippines - Products
"Rebate," "refund," and "reimburse" | Britannica Dictionary
Tyler Sis 360 Louisiana Mo
Culver's Flavor Of The Day Wilson Nc
Clafi Arab
Urinevlekken verwijderen: De meest effectieve methoden - Puurlv
William Spencer Funeral Home Portland Indiana
Zendaya Boob Job
Kaomoji Border
Rhinotimes
Operation Cleanup Schedule Fresno Ca
Buy PoE 2 Chaos Orbs - Cheap Orbs For Sale | Epiccarry
10-Day Weather Forecast for Florence, AL - The Weather Channel | weather.com
Video shows two planes collide while taxiing at airport | CNN
Account Suspended
Satisfactory: How to Make Efficient Factories (Tips, Tricks, & Strategies)
I Saysopensesame
Happy Life 365, Kelly Weekers | 9789021569444 | Boeken | bol
Craigslist Lewes Delaware
Mtr-18W120S150-Ul
Johnnie Walker Double Black Costco
European city that's best to visit from the UK by train has amazing beer
Shoe Station Store Locator
Piri Leaked
Wonder Film Wiki
1636 Pokemon Fire Red U Squirrels Download
Uncovering the Enigmatic Trish Stratus: From Net Worth to Personal Life
Greyson Alexander Thorn
R/Mp5
Experity Installer
Mia Malkova Bio, Net Worth, Age & More - Magzica
Kokomo Mugshots Busted
Indiana Immediate Care.webpay.md
Craigslist Car For Sale By Owner
The 50 Best Albums of 2023
Soulstone Survivors Igg
Bbc Gahuzamiryango Live
The TBM 930 Is Another Daher Masterpiece
Citibank Branch Locations In Orlando Florida
Armageddon Time Showtimes Near Cmx Daytona 12
Unblocked Games Gun Games
Senior Houses For Sale Near Me
FedEx Authorized ShipCenter - Edouard Pack And Ship at Cape Coral, FL - 2301 Del Prado Blvd Ste 690 33990
Holzer Athena Portal
Enter The Gungeon Gunther
Espn Top 300 Non Ppr
The Quiet Girl Showtimes Near Landmark Plaza Frontenac
Dineren en overnachten in Boutique Hotel The Church in Arnhem - Priya Loves Food & Travel
Compete My Workforce
Dumb Money Showtimes Near Regal Stonecrest At Piper Glen
Invitation Quinceanera Espanol
Craigslist Centre Alabama
Latest Posts
Article information

Author: Horacio Brakus JD

Last Updated:

Views: 5364

Rating: 4 / 5 (71 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Horacio Brakus JD

Birthday: 1999-08-21

Address: Apt. 524 43384 Minnie Prairie, South Edda, MA 62804

Phone: +5931039998219

Job: Sales Strategist

Hobby: Sculling, Kitesurfing, Orienteering, Painting, Computer programming, Creative writing, Scuba diving

Introduction: My name is Horacio Brakus JD, I am a lively, splendid, jolly, vivacious, vast, cheerful, agreeable person who loves writing and wants to share my knowledge and understanding with you.