taxman.ge

Tiny tax manager

Summary

• Static client-side CRUD web application.

• Uses public Google APIs.

• Gets exchange rates from the National Bank of Georgia public API.

• Save data in the Google Sheets document as sheets.

Pages

1. Welcome page

Create or select Google Sheets documents.

Buttons:

• Create a new

• Open existing

2. Dashboard page

Monthly income report.

Fields:

• Year

• Month

• Monthly Income

• Monthly VAT

• Monthly Income Tax

• Monthly Amount after taxes.

3. Income page

Add, edit and delete income entries

List Entries.

4. Settings page

Edit income tax and VAT percentages.

Data Sources

1. Senders sheet

• Name
  Non-empty text

• Tax Code
  Text of length between 9 and 11

2. Income sheet

• Date

• Sender
  Reference selector to a sender in the Senders sheet

• Amount
  Numeric, greater than 0

• Currency Name
  Text field, three letter currency ISO code

• Currency Rate
  Numeric, greater than 0

3. Settings Sheet

• Income Tax Percent
  Numeric field,  greater than or equal to 0

• VAT Percent
  Numeric field,  greater than or equal to 0

Integrations

• Google API
  Managing Google Sheets and Drive functionalities

• National Bank of Georgia API
  Provides daily exchange rates.