JS001-FNA-XL ◉ INCOME & EXPENSES

$29.99

   FOR NON ACCOUNTANT

Excel LogoMICROSOFT EXCEL VERSION

$29.99 | Single User |  

$49.99 | Multi User   |  

✔ One Time payment | Instant Download

Description

Excel Accounting Spreadsheet for Non Accountant | Income & Expenses is an Excel spreadsheet for non accounting people to record financial transactions and generate financial reports based on income and expenses records. These are common financial records every small business owners or financial employees usually wrote.

All recorded transactions will be mapped in financial statements with standard Accounting format automatically. Fits to any small business owners and employees who don’t have time to learn accounting but want to generate professional report like Accounting people do.

Also, it is equipped with financial tools to help you solving common financial calculation.

It is a ready to use with integrated worksheets where you just need to do setup once, record transactions, do some transaction adjustment and you are done. Financial reports will be generated automatically. It will cover report up to 5 years.

MENU ▶ Link to any worksheets inside the spreadsheet. No need to move through worksheet tabs at the bottom.

SETUP ▶ Type starting date of your fiscal year (any dates) and adjust Chart of Accounts

INCOME/EXPENSES DATA ENTRY ▶ Entry your income/expenses and adjust them in income/expenses adjustment worksheets (if needed)

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 | Non 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
Up to 5 years fiscal period
Chart Of Accounts 20 parts, 200 lines
fully editable (add, modify)
Income 3500 lines (expandable)
Income Adjustment 3500 lines (expandable)
Expenses 3500 lines (expandable)
Expenses Adjustment 3500 lines (expandable)
General Ledger 500 lines (expandable)
Profit Loss | Format ✔
Profit Loss | Fiscal Year Report ✔
Profit Loss | Monthly Report ✔
Profit Loss | Comparative Report ✔
Balance Sheet | Format ✔
Balance Sheet | Fiscal Year Report ✔
Balance Sheet | Monthly Report ✔
Balance Sheet | Comparative Report ✔
Cash Flow | Format ✔
Cash Flow | Fiscal Year Report ✔
Cash Flow | Monthly Report ✔
Equity | Format ✔
Equity | Fiscal Year Report ✔
Equity | Monthly Report ✔
Dashboard ✔
Depreciation 250 lines (expandable)
Loan Amortization 20 lines
Prepaid | Fixed 100 lines (expandable)
Prepaid | Variable 100 lines (expandable)
CoGS | Inventory 500 items
monthly and fiscal year calculation
CoGS | Inventory Flow 2000 lines (expandable)

Requirement

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

Microsoft Excel 2011, 2016, 2019 for Mac OS X