JS008-FA-XL ◉ MERCHANDISE COMPANY

$29.99

  FOR ACCOUNTANT

Excel LogoMICROSOFT EXCEL VERSION

$29.99 | Single User |  

$49.99 | Multi User   |  

One Time payment | Instant Download

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.

Specification

You will get :

  • One ready to use spreadsheet with modules as listed below
  • One spreadsheet filled with dummy data for reference
  • One User Guide in PDF format

Notes : Inside the spreadsheet, in how to use worksheet, you will find a Youtube link to direct you to user guide in video format.

Modules
Menu
Company Data Start from any dates
Chart Of Accounts 200 lines (expandable)
fully editable (add, modify)
Customer Data 200 lines (expandable)
Supplier Data 200 lines (expandable)
Inventory | CoGS monthly and fiscal year calculation
Inventory | Flow 3500 lines (expandable)
General Journal 3500 lines (expandable)
Cash Journal 3500 lines (expandable)
Purchase Journal 3500 lines (expandable)
Sales Journal 3500 lines (expandable)
Adjusting Journal 3500 lines (expandable)
Closing Journal
General Ledger 500 lines (expandable)
AR And AP Ledger 500 lines (expandable)
Profit Loss | Format 80 lines
Profit Loss | Fiscal Year Report
Profit Loss | Monthly Report
Balance Sheet | Format 100 lines
Balance Sheet | Fiscal Year Report
Balance Sheet | Monthly Report
Cash Flow | Format 120 lines
Cash Flow | Fiscal Year Report
Cash Flow | Monthly Report
Equity | Format 45 lines
Equity | Fiscal Year Report
Equity | Monthly Report
Dashboard
Depreciation 250 lines (expandable)
Petty Cash
Petty Cash Reconcile
Bank Reconcile
Salary
Commission

Requirement

Microsoft Excel 2010, 2013, 2016, 2019 for Windows Vista, 7, 8, 10

Microsoft Excel 2011, 2016, 2019 for Mac OS X