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", "wrOff" and "Sold" transactions (i.e. just the stuff we added)
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 equipment acquisition dates are correct and match a purchase
8. Copy all the sheet content to a new sheet - This removes the filtered out entries
9. Sum up all the costs (column F) - That should be how much equipment we added this year.
10. Go back to original sheet and clear out all filters
11. Filter out Type 2 and 0, and Filter to display Disposal dates for Tax Year
12. Copy the sheet to a temporary sheet
13. Add a column which contains the =YEAR(acq. date) to extract the acq date year
14. Use Subtotal (in Data menu) On "Year Change" sum "Cost"
15. This gives you sales from each year.
16. Put each year's totals in the disposal column.
17. Print the sheet of disposals to attach to PT-50

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.

Once all the transactions are imported, then you can use the following:

(18) Fetch Specific Stock level from Server (use Id on the Resource Product Page URL)

(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.