2022 The Software Group Taxes

Business Transactions

Change Tax Year

Change the tax year to setup the databases and directories.

Preperation Info

CSV files

Download CSV files for Union Bank. They automatically get named TSG.csv and Happenings.csv.

Use the Files/Upload menu to upload files. Upload the files as they were download from the back, the system handles removing the top few lines of the CSV files.

Database

Setting config should create the new databases.

Directory Statuses

Uploaded Files

These files are ready to process.

Processed Files

Records for these files have been uploaded to the database.

The Software Group Checking

Chase1350_Activity_20230403.CSV - April 03 2023 20:15:15.

Chase1350_Activity_20230403_-_Fixed.CSV - April 03 2023 20:38:25.

UB_7046_transactions_2021-01-01_to_2021-12-31.csv - February 09 2022 16:50:02.

UB_7046_transactions_2022-01-01_to_2022-12-31.csv - April 04 2023 01:36:41.

Step by Step Process

Step 1

Upload csv files

CSV Files->Upload CSV

Upload all three CSV files.

Step 2

Process CVS Files - Copies Files to Database.

CSV Files->Process Happenings

CSV Files->Process TSG

Step 3

Run Queries to set categoris of regular entries.

Happenings->Run Queries

TSG->Run Queries

Step 4

Edit Remaining Transactions.

Happenings->Bank Transactions

TSG->Bank Transactions

Cash Transactions

Step 1

Step 2

Step 3

General Notes

The transaction tables are updated right from the csv file from the bank.

It should be okay to add new years to end of table, but maybe back up the file to year numbered file.

Happenings - transaction_hap.

TSG - transaction_tsg.