Description
Google Sheet Accounting System for Service Company is a Google Sheet 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 using Google Sheet and access it from anywhere. 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.
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, adjusting and closing journals.
GENERAL LEDGER ▶ Monitor your transaction by category
FINANCIAL STATEMENT ▶ Analyze and print your report.
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) |
Client Data |
200 lines (expandable) |
Supplier Data |
200 lines (expandable) |
General 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 |
✔ |
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