If you assigned account numbers to your inventory items that you sell, your can produce reports to review a summary or detail for those account.
These are useful if you are diligent and/or want to use it to report items sold for your Resale License, or just to get an idea of what's selling and what's not.

1. Click on "Edit Chart of Accounts" (move it aside) and click on "Edit Inventory Items".

 

In the Chart of Accounts there should be 3 "hard coded" (default) accounts for Income (Room Rentals) credit, Room Rental debit (Chargeable TOT), and Room Rental Tax debit (Amount owed for TOT). (These 3 account numbers are also in the File Maintenance->Edit Defaults, as the original defaults used by the system.) (You can use any series of numbers you like, just remember that up to now, those original defaults accounts have been in use, and are "stamped" onto every current reservation.)

 

2. Now, between the "Chart of Accounts" screen and the "Additional Charges" screen, you can set up many "Tractable", non-TOT, sales and income accounts.

 

3. One of the first numbers you'll want to assign in the Chart file is an account for Resale Tax, and put that into the "Tax Account Number" of the applicable "Additional Charges" items.  (The sales tax amount is also in the Edit Defaults screen.)

 

4. You can make each item you sell a unique number or you can combine them in categories, by assigning the same number.  Just make sure that there is a  "Chart of Accounts" account number that matches the "Additional Charges" account numbers.  (Remember, you don't have to track everything if you don't want.)

 

The most tricky part is for Room Rental Refunds, other types of room charges, cancellation fees, etc (Whether it be a Debit or Credit is crucial for reconciliations.)

----------------------

Now you have all your accounts setup and from now on, all NEW reservations and the Debit and Credit charges will use those numbers.

Now you want to (or probably need to), change (laboriously) all the past charges to the correct new account numbers.

To do this, leave the two screens open, and go back to the "Sales Account Report" screen (Sitting in the background.)

 

1. Adjust the Starting and Ending dates.  (Hopefully you won't have to go back to many years.)  Make sure the Ending Date is past any future reservation. So put "1/1/2020" if you want, just to be safe.

 

2. Click on the "View/Edit Individual Transactions". What you want to do here is assign the correct "Item" and "Tax" account numbers what you assigned in the Chart and Inventory files.  If you scroll down, at some place the screen will start showing the 3 default charge accounts. (You'll have to change them also if you assigned new numbers.)

---------------------

Now you are ready to produce reports.

 

1. Close out the "View/Edit Individual Transactions", "Chart of Accounts", and "Additional Charges" screen.
 

2. Change the Starting and Ending dates to the real ones you want to process.

 

3. Click on "Display Preview" to see how it all looks. From there it is all tweak, tweak, tweak until you get the numbers you are looking for.