Year-End Tax Reporting

Georgia PT-50 Business Assets Reporting

Every year, we have to file a PT-50 form with Chatham County which is used to tax the business assets. We need to account for everything we bought that is rental inventory and deduct sold off stock. Luckily, the record keeping should be mostly done as part of currentRMS.

We use an Excel worksheet to keep track of all the stuff we bought and wrote off/sold over the year. The Spreadsheet is at v:\ADMIN\Taxes\Chatham County Tax Worksheet.

The following is the process to update the worksheet:

1. Run the Stock reporting Python script (v:\z-Misc\stock.py) and use option (40) to generate the jml-transactions.csv file 2. Sort the file by Acquisition Date and then Name 3. Use the Filter to filter out Type 2 (Sale items) so we only have the rental stock displayed 4. Use the filter to only show the Tax Year's Transactions 5. Use the Filter to filter out "Find" transactions 6. Cost column should not be empty. Cost should be 0.01 to indicate that something is part of a bigger package (Cost in the 1st line of comment field in stock level). 7. Make sure cost is accurate

Special Reporting Software

Benoit designed a python program (stored on V:\z-Misc\stock.py) to be able to track the various stock transactions that happen directly from current. This is used mainly to keep track of the rental stock we bought and sell or write-off, since this affects taxes at the end of the year.

This is a program that is very user unfriendly but extracts the info we need.

Whenever a new item is added to current, use option 91 to get a list of all the items. When a new stock transaction happens, use 92 to get all the stock transactions. You can use 99 to perform 91 + 92 at the same time. Once all the transactions are imported, then you can use the following:

(30) Disposal Transactions: Lists all the items that have been disposed of in the file disp.csv (40) Lists ALL the transactions for everything and saves it in jml-transactions.csv (41) Lists the rental item transactions and saves it in jml-transactions-stock.csv (42) Lists the sales items (i.e. expendables) and saves it in jml-transactions-sales.csv

We use (41) to tally all the equipment we purchased over the year. For the current tax year, we use that to ADD to the PT-50 Georgia sheet. We use (30) to tally everything that sold or was written off in a year. This is used for PT-50 reporting to decrease our taxes since we don't have the equipment anymore.