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 - Call this sheet Acq
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
12. Filter to display Disposal dates for Tax Year
13. Copy the sheet to a new Sheet called Disposals
14. Add a column which contains the =YEAR(acq. date) to extract the acq date year
15. Add a column called Gap, which contains the formula =YEAR(J2)-YEAR(G2)+1
16. Add a column called Recap, with formula =IF(C2="Yes",IF(M2>4,F2,F2*M2*0.2),"")
17. Use Subtotal (in Data menu) On "Year Change" sum "Cost" and "Recap"
18. This gives you sales from each year.
19. Put each year's totals in the disposal column.
20. Make a Copy the disposals sheet
21. Delete the Following Columns: Id, Type, A/E, Asset, Transact, Qty, Disp.Qty, Year
22. Add a Title Line: Tax Year Equipment Disposal - JML
23. Save As the workbook in V:/admin/taxes/year/Equipment year.xls
24. Print this sheet of disposals to attach to PT-50

1. The Recap column is used to calculate the Depreciation Recapture which we use for the Federal taxes and put in the PT-50 Worksheet

PT-50 Worksheet

In v:\ADMIN\Taxes, there is an excel sheet called Chatham County Tax Worksheet

It needs to be updated for the current year:

1. Make a Copy of the previous Year's Worksheet and call it current year
2. Move the Year line content down by one and add the current year on line 8
3. copy the values of column I (Adjusted Cost) to Column C (previously reposted)
4. Clear column G (disposals)
5. Copy C20 to C19 (i.e. Current Year to Previous year)

1. Take the total of the Acquisition Sheet and put it in Tax Year's "Additions/Transfers In"
2. On the Disposals Sheet, put the disposals by Year in the "Disposals/Transfers Out" Column
3. On the Disposals Sheet, take a look at the Recap
4. On Quickbooks, look at the <Tax Year> Original Asset Value balance, and put that in the "Asset Add" for current year on the PT-50 worksheet

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.