JS018-FA-GS ◉ MANUFACTURING COMPANY ACCOUNTING CYCLE

$24.99

FOR ACCOUNTANT

GOOGLE SHEET VERSION

$24.99 | Single User |  

$34.99 | Multi User  |  

One Time payment | Instant Download

Microsoft Excel Check Here Button

 

Description

Google Sheet for Manufacturing Company Accounting Cycle is a Google Sheet to record and process all company’s financial transactions from the beginning of the transaction to its representation on the financial statements, to closing the accounts, within one fiscal period, usually one year. It is specifically designed for Manufacturing Companies.

This spreadsheet has accounting cycle diagram as its main menu to help people practicing their accounting skills as well as applying them to process their company’s financial transactions. The main difference between merchandise and manufacturing company in this cycle is the Cost of Goods Manufactured (CoGM) part that should be calculated as part of Cost of Goods Sold (CoGS). Also, there is a CoGM column in Trial Balance table to replace Adjusted Trial Balance column.

FRONT MENU ▶ A clickable accounting cycle diagram

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

1 | TRANSACTIONS ▶ Identify your financial transactions.

2 | JOURNALS ▶ Entry your your transactions in particular journals. There are general and special journals available to write any financial transactions.

3 | GENERAL LEDGER ▶ Monitor your transaction by category. You don’t have to summarize those accounts manually.

4 | UNADJUSTED TRIAL BALANCE ▶ Check accounts summary in trial balance.

5 | ADJUSTING ENTRIES ▶ Adjust any transactions that are needed to be adjusted.

6 | COST of GOODS MANUFACTURED ▶ Check CoGM summary .

7 | FINANCIAL STATEMENT ▶ Analyze and print your report.

8 | CLOSING JOURNAL ▶ Close income and withdrawal into owner’s equities

9 | POST CLOSING TRIAL BALANCE ▶ Check accounts summary after closing entries.

10 | REVERSING ENTRIES ▶ Prepare subsequent fiscal year by adjusting some entries (if needed).

You can read more information in journalSHEET | be 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
Setup Start from any dates
Custom start and end date report period
Chart Of Accounts 200 lines (expandable)
fully editable (add, modify)
Subsidiary Accounts 200 lines (expandable)
fully editable (add, modify)
Transactions
General Journal 3500 lines (expandable)
Special Journal 3500 lines (expandable)
Adjusting Journal 3500 lines (expandable)
Closing Journal
General Ledger 250 lines (expandable)
Custom start and end date report period
Subsidiary Ledger 250 lines (expandable)
Custom start and end date report period
Profit Loss | Format 80 lines
Profit Loss | Fiscal Year Report
Balance Sheet | Format 100 lines
Balance Sheet | Fiscal Year Report
Cash Flow | Format 120 lines
Cash Flow | Fiscal Year Report
Equity | Format 45 lines
Equity | Fiscal Year Report

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