Google-Sheets-Accounting-Tools

Google Apps Scripts written in JavaScript to automate GAAP accounting and inventory management within a centralized Google Sheet.

Features

• Automated journal entries
• Synchronization between general ledger and accounting equation
• Inventory tracking and management with availability heatmap
• Integration with Google Sheets

Installation

1. Clone this repository.
2. Open your Google Sheet.
3. Go to Extensions > Apps Script.
4. Copy the script files from this repo into the Apps Script editor.
5. Save and authorize the script.

Usage

Setting up Inventory Management

• Assign the universal_inc() and universal_dec() scripts to two shapes in Google Sheet.
• For each item, list serial#/ID with height range (5'8"-6'1") and weight range (150-164 lbs) 3 and 4 cells below.
• designate the range C3:AA27 as the heatmap where the y-axis ranges from 4'6" to 6'6", and the x-axis from 80 to 210 lbs.
• When adding to inventory, select the item ID and click inc or dec to update the heatmap.

Setting up GAAP automation

• In a page named "journal", Assign the equationLog(), deleteEntry() scripts to two shapes in Google Sheet.
• Create as many new shapes as you'd like assigning them templated calls to newJournalEntry().
• Create the General Ledger with Transaction ID, Date, Account Titles and Description, Debit, and Credit columns beginning in D3.
• Click any of your templated scripts to add a new transaction with todays date and newest ID.
• When done, highlight the IDs to be logged and then click the equationLog() shape to add to the "Equation" page.

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

License

LICENSE