Bookkeeping Spreadsheet for Non Accountant

Bookkeeping spreadsheet for non accountant is a spreadsheet to help you recording your company financial transaction regularly – WITHOUT ACCOUNTING KNOWLEDGE – and generate financial statement with standard accounting format automatically.

HOW IS IT POSSIBLE?

Accounting is founded before computer era where any calculation must be done manually. Our predecessor were developing writing format to ease them on creating financial statements as well as audit them. Now, you don’t have to follow their steps since computers are already doing those calculation for you.

This bookkeeping spreadsheet is designed to help you to do your business and record your transactions as usual and let the financial calculation help you in the background to produce financial statements like accounting people do.

It uses Microsoft Excel. We believe you already familiar with this. So, you don’t have to learn how to use it.

Bookkeeping Spreadsheet for Non Accountant - Features

Basically, these bookkeeping spreadsheets are divided into three models:

Services Business
Merchandising/Trading Business
Manufacturing Business

But, there are many variations in actual business where some are combination of those three above and some are modified version of those business models.

We realize that you might have some difficulties on categorizing your business. That’s why we create samples, NOT JUST A FEW – BUT HUNDREDS, so you can select the closest sample with your business.

SETUP THE SPREADSHEET

Bookkeeping Spreadsheet for Non Accountant - Setup

Depends on the model, this bookkeeping spreadsheet requires you customize it first. It starts from the date. You can SET IT TO ANY DATES. Then, you can start to record your transactions within one year period.

RECORD REGULAR TRANSACTION

Bookkeeping Spreadsheet for Non Accountant - Transaction Modules

Transaction modules, or journal in accounting terms, are designed to follow your regular data entry transactions. There are sales, purchase and other income | expenses transaction modules. YOU CAN COPY & PASTE data from your Excel file. Pick categories for those transactions (there are transaction CHEAT SHEET included in the package to help you categorize your transaction correctly) and that’s all. Formulas in the background will calculate and summarize them in financial statements automatically.

PRINT INVOICE – PURCHASE ORDER – CASH RECEIPT

Bookkeeping Spreadsheet for Non Accountant - Receipts

There are invoice, purchase order and cash receipts you can print, either for your own copy (save as pdf file) or to send to your customers and suppliers.

Notes: for cash receipts, words for values are in US format.

TRACK & MONITOR ACCOUNT PAYABLE & RECEIVABLE

Bookkeeping Spreadsheet for Non Accountant - Account Payable Receivable

TRACK & MONITOR INVENTORY

Bookkeeping Spreadsheet for Non Accountant - Inventory Modules

There are inventory formulas that will help you calculating stock balance automatically. It includes COGS formulas that will calculate cost of your sales automatically.

You don’t have to calculate them manually. Stock and COGS calculator will do it for you.

ANALYZE FINANCIAL STATEMENTS

Bookkeeping Spreadsheet for Non Accountant - Financial Statements

See the financial statements. All are following standard accounting format. It is similar with what accounting people do to record the transaction in accounting way. It is more than enough for any small business owners to get a rough figure of their businesses.

Financial Dashboard is included.