JS005-FNA-GS ◉ INVOICE & PURCHASE ORDER

$39.99

FOR NON ACCOUNTANT

GOOGLE SHEET VERSION

$39.99 | Single User |  

$59.99 | Multi User   |  

One Time payment | Instant Download

Microsoft Excel Check Here Button

Description

Google Sheets Non Accountant Spreadsheet | Invoice & Purchase Order is a Google Sheet for non accounting people to record financial transactions and generate financial reports based on income and expenses records with additional Invoice and Purchase Order as additional detail information. These invoices and purchase orders will be used to calculate Cost of Goods Sold (CoGS) for particular products.

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.

CONTROL YOUR OWN CLOUD COMPUTING SERVICE

It is a ready to use with integrated worksheets where you just need to do setup once, copy and paste your bank statement, 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). Include invoices and purchase orders detail information in respective columns

GENERAL LEDGER ▶ Monitor your transaction by category

ACCOUNT RECEIVABLE & PAYABLE LEDGER ▶ Monitor receivables for particular customers and payables for particular suppliers

FINANCIAL STATEMENT ▶ Analyze and print your report. Automatically generated.

DASHBOARD ▶ Evaluate your financial situation in Chart Visualization

All worksheets are FULLY EDITABLE. It will allow you to edit it anywhere at any place.

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 with Invoice Data 3500 lines (expandable)
Income Adjustment 3500 lines (expandable)
Expenses with PO Data 3500 lines (expandable)
Expenses Adjustment 3500 lines (expandable)
General Ledger 500 lines (expandable)
Account Receivable and Payable 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
Inventory 500 items
monthly and fiscal year calculation

Compatibility

Google Sheet will save any data entries automatically. Processing speed depends on your internet connection and Google server where your spreadsheet is located.

You can also use this spreadsheet to work on other spreadsheet processor and cloud services below :

  • Microsoft Excel 2010, 2013, 2016, 2019 for Windows Vista, 7, 8, 10
  • Microsoft Excel 2011, 2016, 2019 for Mac OS X
  • Numbers on Mac
  • Office 365