Using Spreadsheets For Small Business Accounting

simple bookkeeping spreadsheet

Each category of account has different accounts in it. For example, assets accounts can contain accounts such as cash, accounts receivable, inventory, fixed assets, or other assets. Accounts receivable are payments owed to you for purchases from you using credit. The different categories of accounts are asset, liability, equity, revenue, and expense accounts. Small businesses may have equity accounts if they have investors or use a type of equity financing. That could be a credit or bank card statement, info in your Paypal account, or receipt from a cash payment. First, download a free invoice template for Excel, or get one for Google Sheets.

On the off chance that you’ve procured an accountant as opposed to doing it without anyone else’s help; monitor the clerk to ensure he’s completing legit work. Make your financing and bookkeeping simple by getting these templates. Jon Steiert is a content writer income summary focused on making business and financial information accessible to any business owner. He’s always on the lookout for fascinating stories that just haven’t been told properly. Updating your books is an essential part of keeping your finances in order.

This contains details of every business transaction you perform—the date, a description, the amount, and the account. We’ll show you how, using Bench’s Income Statement Excel Template to get started. So, with these essential pieces of your Excel bookkeeping system in mind, let’s discuss how you can take one of these templates, customize it, and use it to maintain your books. Now that we know a little bit more about what Excel bookkeeping will entail, let’s discuss what you’ll need to do to actually create your own system for your small business. NerdWallet’s ratings are determined by our editorial team.

  • We’ve modified it by renaming “Sales” to “Contributions” and deleting a few columns we don’t need.
  • A debit in accounts payable decreases the account value, while in an account receivable a debit increases the account value.
  • If this is the case for you, you need to add up those expenses and plug it into this cell under the corresponding month and you’re all done!
  • This lists all the accounts that make up your books.

Last, but certainly not least, is this Marketing KPIs template. Track all of your marketing efforts through this single spreadsheet system. Tracking all the different marketing channels your company uses can be tricky. This single spreadsheet system can combine SEM, SEO, email marketing, content marketing, and social media marketing among many others. Don’t keep it locked away in imprecise stock numbers. Upgrade your inventory report with this great template.

Travel Itinerary Template

The bookkeeping entry for as sales invoice is basic. Enter the date of the invoice, name of client, sales invoice number if applicable and optionally a very brief description of the product sold.

simple bookkeeping spreadsheet

Simply fill in the information for the person you’re sending the invoice to, and their custom invoice is created instantly when you run the script. This is what we mean when we say that templates can truly power up your Google Sheets experience. Our accounting templates are created in Microsoft Excel but you should be able to use them with Mac Numbers, OpenOffice and Google Spreadsheets without any issues. Please save all receipts and file them by MONTH so you can refer to anything if something seems off or confusing from your bank statement. If you are advertising by other means such as Facebook or Google, I would recommend logging into your ad account and they should have reports to show you how much you spent and when it was billed. If it was billed in that month you are doing bookkeeping for, then thats it! On the second sheet of the worksheet I gave you, there is a place for you to fill out that ENTIRE bill.

These templates cover a wide range of budgeting needs, from a basic overview of your business income and expenses to marketing budget templates. The startup budget template is ideal for newbie entrepreneurs still in the planning stage of their businesses.

Youre Our First Priority Every Time

You will soon discover that it takes no time if you keep on top of it, and at tax time you will be so glad you did. You can also create formulas Accounting Periods and Methods in different cells to keep running totals, or if you are very adept with spreadsheets, you can do things like a link to other sheets.

Thistax expense templatecan make calculating a running total of your expenses a breeze, while thisIRS audit info trackerallows you to itemize any requested documents during a tax audit. When using accrual accounting, ensure simple bookkeeping spreadsheet that every time a debt is recorded, another account is credited. Make an account type chart to reference discern when debiting or crediting an account. Deleting certain columns will create errors in the spreadsheet.

This balance sheet template shows a company’s financial position, at a given moment. Use this balance sheet template to summarize your company’s assets, liabilities and owner’s equity.

The excel cash book template tracks your daily and monthly transactions to control your profits or loss. Cash Book is just like a ledger account because it includes your cash and bank transactions. The profit & loss statement shows your revenue/income and expenses and tells you how profitable your business has been over a designated period. It also breaks down your revenue and expenses in detail, so you know exactly how you make and how you spend. Looking for an income statement example to use for your business? Click to download our free Microsoft Excel-basedsample income statement template. With the free bookkeeping software from FreshBooks, you will have a helpful guide to creating your own financial statements.

Serve more customers with better supply distribution. This is a very powerful tool if you work with invoices. Design your template once and never bother with it again.

Its Not Generally Accepted In The Business World

In the next column would be the total sales invoice amount. If items like value added tax are required to be accounted for then an additional column would be required to accommodate the vat or sales tax accounting. Examples of third party evidence would be sales invoices, purchases invoices and bank statements. Again, another one that is simple and straight forward. I pay my sales tax every quarter so this row will only get filled out when that expense has hit my bank account.

simple bookkeeping spreadsheet

While different businesses will want different styles of accounts payable spreadsheets, thisinvoice tracker templateis a good example of how even the most simple setup can save you time. This year-to-yearbalance sheet templateshows how you can use Excel accounting spreadsheets to track how the revenue from your accounts payable changes over time. The third and final sheet of any single entry bookkeeping template is the Transactions tab. Here, you’ll input the Date, Description of the Transaction, Amount and Category.

Account Payable

If you’re a have a very small business or side hustle, an Excel bookkeeping system may be all you need. On the other hand, if you plan on growing or expanding your business in any real capacity, you’re going to want to invest in bookkeeping or accounting software. First, thechart of accountsis the bookkeeping Excel sheet that will include all of the accounts that make up your books. Every transaction you record needs to get sorted into one of these categories.

You could list them by account type (asset, liability, etc.) to make it easier to understand. In the next column, assign a number to each account. Decide how many worksheets you want to use for your accounts. By default a new workbook contains three, with each one accessible from the tabs at the bottom of the window.

Everybody loves to see their business in the black. With the free Accounting Templates from FreshBook, staying on top of your business accounting is well within reach. One concept that confuses many people is that it is possible to increase two different accounts. If you purchase a piece of equipment on credit, you would increase your asset account with the value of the item, and increase your liability account . If you are using the accrual basis accounting method or double-entry accounting, you’ll need to prepare different accounts. The accounting equation is the guideline for all transactions. By the end of every month, the Income Sheet should have all the data it needs to summarize your bookkeeping for that period.

This places those cells you highlighted in an accounting format, automatically placing a dollar sign in them. Equity accounts are usually owners’ or stockholders’ equity accounts, but small businesses may not have any shareholders. If this is the case, it is generally called owners’ equity. Retained earnings are included in the equity accounts because it is the profit a company has earned over its lifetime after paying any dividends . These earnings are usually saved, or reinvested in the company. Data entry – Manually entering and categorizing transactions for your books is starting to take up too much of your time.

Formulas And Formats For Accounting

Within this document and these three sheets, you’ll be able to enter and categorize your transactions and generate income statements. Excel may be useful for data analysts who are crunching numbers and running pivot tables.

Credit Tools

Single-entry bookkeeping is a good choice if you run a small, simple business with a low volume of transactions. Every time money enters or leaves your business, it’s recorded once, as a positive or negative value. It’s important to note that your chart of accounts doesn’t have to look exactly like this one—after all, every business has different income and expenses. Although it is technically possible to create a double-entry accounting system in Excel, we wouldn’t advise doing so.

If you can afford it and have the time to learn it, double entry software is usually the best for your accounting needs. See mydouble entry bookkeepingpage for the difference between single and double entry accounting systems. All of my free accounting workbooks are single entry accounting spreadsheets. It not only provides you with expertly formatted bookkeeping spreadsheets, but documents all of your important financial information. Take control of your finances with FreshBooks, and make the decisions your business deserves. Equity is also an essential component of a simple balance sheet. You can calculate equity by subtracting your liabilities from your assets.

Later, J.P. Morgan Chase lost over $2 billion due to a spreadsheet error, which was compounded because a single miscalculation was fed into other calculations. If you want a Manual Cash Book solution then I have this as well and it works exactly the same way as the small business template – just with Etsy categories already set-up for you. Just answer the same questions to choose the right template. You can see your sales and all your fees by category so you know exactly what you have earned and been charged without having to extract the right numbers yourself.

Better yet, you can customize them to suit the unique needs of your business. If you are a small business owner, you can select from a range of retail business accounting templates to get started. We’re an online bookkeeping service powered by real humans. Bench gives you a dedicated bookkeeper supported by a team of knowledgeable small business experts.

I have figured out how to fix the totals bars to show the correct total but I can’t figure out how to make the “ok” “oops” bar to correctly work past the 360 slot. Karen, If you’re using the excel spreadsheet, take care that, when you first download it, you permit Excel to edit it. An MS Excel spreadsheet template is a spreadsheet that has been setup, configured and protected to allow data entry in predetermined cells. A Bookkeeping Spreadsheet Template for your Website is the best way to start your own company. This template will ensure that you have a form to fill in and an accounting function, this means that you can give out some accurate information.

Just add the date, description and amount and choose a category from a list that you create when you set up the spreadsheet. Spreadsheets are incredibly helpful for tracking cash flow, particularly in terms of accrual accounting and cash basis accounting. For business owners, knowing whether a business is making profits or not is vital for growing the business. Thus, the way to do this is to create a profit & loss statement, which can use to generate your monthly financial report.

Author: Craig W. Smalley, E.A.

Leave a reply