Description
Excel Accounting Spreadsheet for Merchandise 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 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 purchase and sell similar products where price differences are company’s profit. 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.
DASHBOARD ▶ Evaluate your financial situation in Chart Visualization
You can read more information in journalSHEET | Accountant info page.