Description
Excel Accounting Spreadsheet for Manufacturing Company is an Excel Spreadsheet for accounting people to record financial transactions and generate financial reports by following accounting double entry bookkeeping system. Fits to you who wants to monitor and track your business using Microsoft Excel and don’t want to spend time on sophisticated and standalone accounting software. All recorded transactions will be mapped in financial statements with standard Accounting format.
Type of businesses in this category are trading companies who produce and sell products. Also, it accommodates companies who sell products and services.
Since this spreadsheet is following accounting method, you who already understand accounting won’t have any difficulties on using it. Furthermore, it is an Excel spreadsheet that will allow you to explore and customize it to suit your own needs.
FRONT MENU ▶ Link to any worksheets inside the spreadsheet. It should quicken access to particular worksheet.
SETUP ▶ Type starting date of your fiscal year (any dates) and adjust Chart of Accounts
JOURNALS ▶ Entry your your transactions in particular journals. There are general, cash, sales, purchase, adjusting and closing journals.
GENERAL LEDGER ▶ Monitor your transaction by category
FINANCIAL STATEMENT ▶ Analyze and print your report. Automatically generated. There is additional Schedule of Cost of Goods Manufactured as part of the report.
DASHBOARD ▶ Evaluate your financial situation in Chart Visualization
You can read more information in journalSHEET | Accountant info page.