JS006-FNA-GS ◉ CHECKING ACCOUNTS

$34.99

FOR NON ACCOUNTANT

GOOGLE SHEET VERSION

$34.99 | Single User |  

$54.99 | Multi User   |  

One Time payment | Instant Download

Microsoft Excel Check Here Button

Description

Google Sheet Non Accountant Spreadsheet | Checking Accounts is a Google Sheet for non accounting people to record financial transactions and generate financial reports based on bank statements. Fits with you who monitor and track your business based on bank statements.

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 bank statements, do some transaction adjustment and you are done. Financial reports will be generated automatically. It will cover report up to 5 years.

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

BANK/NON BANK STATEMENT DATA ENTRY ▶ Entry your bank statement and adjust them in non bank statement 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

All those worksheets are FULLY EDITABLE where you can edit it anywhere any place. It is a cloud spreadsheet.

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)
Bank Statement 3500 lines (expandable)
Non Bank Statement 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

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