Exhibit D Accounting Reports.xlsx
XLSX spreadsheet 202 KB Posted
- Attached to
- Master Agreement AZ|CTR057864
- Contract number
- CTR057864
- Issued by
- Arizona
About this file
This document is a comprehensive financial accounting report for Arizona State Parks, specifically Exhibit D Accounting Reports, encompassing multiple state parks and facilities across Arizona. The report includes detailed financial records for 29 different parks and facilities such as Alamo Lake, Lost Dutchman, Kartchner Caverns, and others, along with central office and gift shop locations. The documentation appears to be a treasury and revenue tracking document generated for the Arizona Department of Parks and Recreation (DPR), covering financial transactions for the month of December 2020.
The report provides granular financial data including revenue streams from various sources such as camping permits, day use/entrance fees, cave tours, reservations, passes, and miscellaneous income. Total park system revenues for the period were $1,379,177.73, with individual park revenues ranging from $0 (San Rafael) to $167,576.50 (Lost Dutchman State Park). The document breaks down revenues by specific revenue codes, payment types (cash, credit card), and includes detailed tracking of reservation surcharges, refunds, and different pass categories. The report demonstrates a comprehensive financial management approach with multiple levels of revenue classification and tracking across the state park system.
View the file
Other files
Show all 29
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Exhibit 1- Recap Accounting-> Trial Balance (Recap Report)
| *This report records sub revenue codes by: Payment Type (Cash, Check, CC, Refunds) and COA Type |
| *It also does a subtotal of the sub revenue codes that roll up under each revenue code |
| *We would like to continue to report by sub rev codes on this report |
| Lost Dutchman State Park | By park & total for all parks | |
| Income / Sales Reconciliation: 1/24/21 to 1/24/21 | Report Generated: January 25, 2021 12:18 PM | Ability to select date range |
| SUN | ||||
| INCOME BY PAYMENT TYPE | ACCOUNT | 1/24/21 | TOTALS | List all applicable payment types |
| Cash | 1000.076. | $746.89 | $746.89 | |
| Visa/MC | 2000.504. | $6,767.62 | $6,767.62 | |
| INCOME TOTAL: | $7,514.51 | $7,514.51 | ||
| SALES BY COA TYPE | List all applicable Chart of Accounts | |||
| Day Use/Entrance Fee | 4320.100. | $1,238.00 | $1,238.00 | |
| SUBTOTAL: | $1,238.00 | $1,238.00 |
| Pubs Non-Taxable | 4372.100. | $4.75 | $4.75 |
| SUBTOTAL: | $4.75 | $4.75 |
| Camping | 4432.100. | $5,210.00 | $5,210.00 |
| Camping Discount | 4432.110. | ($1.18) | ($1.18) |
| Camping Add Vehicle | 4432.120. | $30.00 | $30.00 |
| Cabin (also Pet Fee) | 4432.200. | $623.00 | $623.00 |
| SUBTOTAL: | $5,861.82 | $5,861.82 |
| Non-Ref Reserv Fee - Camp/Cabin/Cabana | 4449.200. | $350.00 | $350.00 |
| Non-Ref Reserv Fee - Other Facilities | 4449.300. | $5.00 | $5.00 |
| SUBTOTAL: | $355.00 | $355.00 |
| Rental - Other Facilities | 4632.100. | $25.00 | $25.00 |
| SUBTOTAL: | $25.00 | $25.00 |
| Pubs Taxable | 4699.100. | $27.98 | $27.98 |
| Pubs Sales Tax | 4699.101. | $1.96 | $1.96 |
| SUBTOTAL: | $29.94 | $29.94 |
SALES TOTAL: $7,514.51 $7,514.51
INCOME/SALES VARIANCE: $0.00 $0.00
| SUN | ||
| DAILY CASH RECONCILIATION | 1/24/21 | TOTALS |
| Total Cash in Drawer | $0.00 | $0.00 |
| Total Checks in Drawer | $0.00 | $0.00 |
| Less Starting Till Amount (-) | $0.00 | N/A |
| Cash/Check Deposit Total (must equal deposit slip) | $0.00 | $0.00 |
| TOTAL CASH OVER/SHORT: | ($746.89) | ($746.89) |
| Prepared By: | Date: |
| Reviewed By: | Date: |
| Notes: | |
| Key Variance Explanation: |
| SUN | ||
| STANDARD ANNUAL PASSES | 1/24/21 | TOTALS |
| Standard Pass : Beginning No: | 0 | |
| Standard Pass : Ending No: | 0 | |
| TOTAL SOLD: | 0 | 0 |
| PREMIUM ANNUAL PASSES | ||
| Premium Pass : Beginning No: | 0 | |
| Premium Pass : Ending No: | 0 | |
| TOTAL SOLD: | 0 | 0 |
| COMMERCIAL ANNUAL PASSES | ||
| Commercial Pass : Beginning No: | 0 | |
| Commercial Pass : Ending No: | 0 | |
| TOTAL SOLD: | 0 | 0 |
| OTHER (use for breaks in pass numbers above) | ||
| Additional Pass : Beginning No: | 0 | |
| Additional Pass : Ending No: | 0 | |
| TOTAL SOLD: | 0 | 0 |
Exhibit 2- Refund Statewide --> Phoenix Check Refund report
*This report shows allt he refunds that need to be refunded to each customer. This provides the Park name, date, Invoice, amount, Customer information, If the refund was processed, warrant number and description/notes.
| Requests: |
| * Would like to be able to pull same report by column - Processed? (Yes or No) |
| *Add column with two letter initials of the Parks (Ex: Lost Dutchman = LD) - If cannot add this column, not an issue |
Exhibit 3 - Treasury new
Statewide --> Trial Balance Report (Treasury Report)
| DPR | Batch number | 1 | *Rev code to Roll up to one 4439 - sub rev code 4439.001 (combine) | ||||||||||||||||||||||||||||||||||||||||||
| Park | Date Range | Camping | Day Use | ADU | Total Attendance | Camping 4432 | Day Use 4320 | KC/Cave Tour 4332 | Premium 4439 | Standard 4439 | Commercial 4439 | Permits 4339 | Over/Short | Rental Facilities 4632 | 26933-4645 Credit Card Fees | Total Ticket Revenue | Concession 4323 | Other Income 4636 | Housing | SPRF Total Ticket Concess & other Revs | Park | 07693-4449 Reservation Surcharge Camping/Other | 07693-4449 Reservation Surcharge Cave Tour | PCA-06633 Gift Shop Taxable 4699 | PCA-06633 Gift Shop Non-Taxable 4372 | Over/Short | Total Gift Shop | AL-06123 LL=06373 Game & Fish-4416 | SPRF Total Revenues | Project Box | Donations Main Acct. | Total Donations | TOTAL All Funds | Parks | Voucher +/- Refunds + Concessions | Credit Card Deposits | Cash/Checks Deposits | Document Number | Donations PCA | Project Number | Authorize.net CC | Difference | Verify Total Funds | 2 | |
| Alamo Lake | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $55,930.00 | $1,448.00 | $0.00 | $0.00 | $675.00 | $0.00 | $0.00 | $0.00 | $50.00 | $0.00 | $58,103.00 | $0.00 | $0.00 | $0.00 | $58,103.00 | Alamo Lake | $5,185.00 | $0.00 | $4,837.19 | $1,947.20 | $0.00 | $0.00 | $6,784.39 | $0.00 | $70,072.39 | $0.00 | $118.70 | $118.70 | $70,191.09 | Alamo Lake | $0.00 | $64,918.54 | $5,862.55 | DPR | 81120 | 809212-00 | $0.00 | ($64,918.54) | $5,862.55 | 3 |
| Boyce Thompson | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Boyce Thompson | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Boyce Thompson | $0.00 | $0.00 | $0.00 | DPR | XXXXX | XXXXXX-XX | $0.00 | $0.00 | $0.00 | 4 |
| Buckskin Mountain | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $51,336.00 | $1,652.50 | $0.00 | $200.00 | $300.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $53,488.50 | $0.00 | $0.00 | $0.00 | $53,488.50 | Buckskin Mountain | $3,500.00 | $0.00 | $4,271.42 | $874.40 | $0.00 | $0.00 | $5,145.82 | $0.00 | $62,134.32 | $0.00 | $82.00 | $82.00 | $62,216.32 | Buckskin Mountain | $0.00 | $60,305.93 | $5,351.40 | DPR | 81130 | 809213-00 | $0.00 | ($60,305.93) | $5,351.40 | 5 |
| Catalina | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $78,491.00 | $25,962.00 | $0.00 | $0.00 | $41,700.00 | $0.00 | $0.00 | $0.00 | ($45.00) | $0.00 | $146,108.00 | $0.00 | $0.00 | $0.00 | $146,108.00 | Catalina | $7,975.00 | $0.00 | $5,296.79 | $356.70 | $0.00 | $0.00 | $5,653.49 | $0.00 | $159,736.49 | $0.00 | $20.00 | $20.00 | $159,756.49 | Catalina | $0.00 | $140,771.42 | $23,700.07 | DPR | 81330 | 809233-00 | $0.00 | ($140,771.42) | $23,700.07 | 6 |
| Cattail Cove | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $36,375.00 | $3,519.00 | $0.00 | $400.00 | $750.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $41,044.00 | $0.00 | $0.00 | $0.00 | $41,044.00 | Cattail Cove | $2,845.00 | $0.00 | $2,817.13 | $377.10 | $0.00 | $0.00 | $3,194.23 | $0.00 | $47,083.23 | $0.00 | $20.00 | $20.00 | $47,103.23 | Cattail Cove | $0.00 | $43,481.46 | $4,726.77 | DPR | 81140 | 809214-00 | $0.00 | ($43,481.46) | $4,726.77 | 7 |
| Dead Horse Ranch | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $106,797.00 | $11,150.50 | $0.00 | $0.00 | $12,150.00 | $700.00 | $102.00 | $0.00 | $0.00 | $0.00 | $130,899.50 | $0.00 | $0.00 | $0.00 | $130,899.50 | Dead Horse Ranch | $7,845.00 | $0.00 | $6,176.27 | $336.93 | $0.00 | $0.00 | $6,513.20 | $0.00 | $145,257.70 | $0.00 | $24.11 | $24.11 | $145,281.81 | Dead Horse Ranch | $0.00 | $130,521.17 | $15,850.64 | DPR | 81220 | 809222-00 | $0.00 | ($130,521.17) | $15,850.64 | 8 |
| Fool Hollow Lake | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $21,966.00 | $4,363.00 | $0.00 | $0.00 | $600.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $26,929.00 | $0.00 | $0.00 | $0.00 | $26,929.00 | Fool Hollow Lake | $1,645.00 | $0.00 | $450.53 | $11.99 | $0.00 | $0.00 | $462.52 | $0.00 | $29,036.52 | $0.00 | $0.75 | $0.75 | $29,037.27 | Fool Hollow Lake | $0.00 | $25,750.32 | $3,296.95 | DPR | 81340 | 809234-00 | $0.00 | ($25,750.32) | $3,296.95 | 9 |
| Fort Verde | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $0.00 | $2,132.00 | $0.00 | $0.00 | $450.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,582.00 | $0.00 | $0.00 | $0.00 | $2,582.00 | Fort Verde | $0.00 | $0.00 | $1,043.50 | $25.49 | $0.00 | $0.00 | $1,068.99 | $0.00 | $3,650.99 | $0.00 | $0.00 | $0.00 | $3,650.99 | Fort Verde | $0.00 | $2,723.99 | $943.99 | DPR | 81230 | 809223-00 | $0.00 | ($2,723.99) | $943.99 | 10 |
| Homolovi | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $12,016.00 | $619.50 | $0.00 | $0.00 | $75.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $12,710.50 | $0.00 | $0.00 | $0.00 | $12,710.50 | Homolovi | $895.00 | $0.00 | $1,180.90 | $56.18 | $0.00 | $0.00 | $1,237.08 | $0.00 | $14,842.58 | $0.00 | $57.00 | $57.00 | $14,899.58 | Homolovi | $0.00 | $12,204.09 | $2,800.54 | DPR | 81240 | 809224-00 | $0.00 | ($12,204.09) | $2,800.54 | 11 |
| Jerome | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $0.00 | $10,394.00 | $0.00 | $0.00 | $300.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $10,694.00 | $0.00 | $0.00 | $0.00 | $10,694.00 | Jerome | $0.00 | $0.00 | $5,668.86 | $406.58 | $0.00 | $0.00 | $6,075.44 | $0.00 | $16,769.44 | $0.00 | $0.00 | $0.00 | $16,769.44 | Jerome | $0.00 | $13,601.71 | $3,167.73 | DPR | 81250 | 809225-00 | $0.00 | ($13,601.71) | $3,167.73 | 12 |
| Kartchner Caverns | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $36,825.00 | $1,882.50 | $18,584.00 | $0.00 | $750.00 | $0.00 | $150.00 | $0.00 | $275.00 | $0.00 | $58,466.50 | $0.00 | $260.00 | $0.00 | $58,726.50 | Kartchner Caverns | $5,212.00 | $2,664.00 | $2,380.00 | $0.00 | $0.00 | $0.00 | $2,380.00 | $0.00 | $68,982.50 | $0.00 | $427.00 | $427.00 | $69,409.50 | Kartchner Caverns | $0.00 | $64,334.50 | $3,608.00 | DPR | 81350 | 809235-00 | $0.00 | ($64,334.50) | $3,608.00 | 13 |
| Lake Havasu | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $82,369.00 | $16,503.50 | $0.00 | $11,200.00 | $3,975.00 | $4,550.00 | $200.00 | $0.00 | $165.00 | $0.00 | $118,962.50 | $0.00 | $0.00 | $0.00 | $118,962.50 | Lake Havasu | $6,891.00 | $0.00 | $224.08 | $33.98 | $0.00 | $0.00 | $258.06 | $0.00 | $126,111.56 | $0.00 | $15.51 | $15.51 | $126,127.07 | Lake Havasu | $0.00 | $111,169.93 | $19,502.14 | DPR | 81150 | 809215-00 | $0.00 | ($111,169.93) | $19,502.14 | 14 |
| Lost Dutchman | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $88,520.71 | $47,695.50 | $0.00 | $400.00 | $12,525.00 | $0.00 | $100.00 | $0.00 | ($200.00) | $0.00 | $149,041.21 | $0.00 | $0.00 | $0.00 | $149,041.21 | Lost Dutchman | $9,270.00 | $0.00 | $7,817.24 | $1,438.55 | $0.00 | $0.00 | $9,255.79 | $0.00 | $167,567.00 | $0.00 | $9.50 | $9.50 | $167,576.50 | Lost Dutchman | $0.00 | $141,906.80 | $38,279.69 | DPR | 81360 | 809236-00 | $0.00 | ($141,906.80) | $38,279.69 | 15 |
| Lyman Lake | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $14,753.00 | $251.50 | $0.00 | $0.00 | $150.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $15,154.50 | $0.00 | $0.00 | $0.00 | $15,154.50 | Lyman Lake | $845.00 | $0.00 | $649.86 | $179.65 | $0.00 | $0.00 | $829.51 | $40.00 | $16,869.01 | $0.00 | $12.01 | $12.01 | $16,881.02 | Lyman Lake | $0.00 | $16,274.01 | $615.48 | DPR | 81370 | 809237-00 | $0.00 | ($16,274.01) | $615.48 | 16 |
| Oracle | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $0.00 | $1,505.00 | $0.00 | $0.00 | $3,075.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $4,580.00 | $0.00 | $0.00 | $0.00 | $4,580.00 | Oracle | $0.00 | $0.00 | $1,228.98 | $46.54 | $0.00 | $0.00 | $1,275.52 | $0.00 | $5,855.52 | $0.00 | $13.00 | $13.00 | $5,868.52 | Oracle | $0.00 | $4,055.81 | $1,816.20 | DPR | 81390 | 809239-00 | $0.00 | ($4,055.81) | $1,816.20 | 17 |
| Patagonia Lake | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $84,879.50 | $13,565.50 | $0.00 | $600.00 | $4,050.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $103,095.00 | $0.00 | $0.00 | $0.00 | $103,095.00 | Patagonia Lake | $7,540.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $110,635.00 | $0.00 | $33.00 | $33.00 | $110,668.00 | Patagonia Lake | $0.00 | $100,521.50 | $11,064.50 | DPR | 81410 | 809241-00 | $0.00 | ($100,521.50) | $11,064.50 | 18 |
| PHX OFC Gift Shop 1300 | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $8,200.00 | $37,425.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $45,625.00 | $0.00 | $0.00 | $0.00 | $45,625.00 | PHX OFC Gift Shop 1300 | $0.00 | $0.00 | $485.07 | $14,527.48 | $0.00 | $0.00 | $15,012.55 | $0.00 | $60,637.55 | $0.00 | $0.00 | $0.00 | $60,637.55 | PHX OFC Gift Shop 1300 | $0.00 | $60,375.60 | $147.95 | DPR | XXXXX | XXXXXX-XX | $0.00 | ($60,375.60) | $147.95 | 19 |
| SW Gift Shop 1616 | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | SW Gift Shop 1616 | $0.00 | $0.00 | $0.00 | $80.50 | $0.00 | $0.00 | $80.50 | $0.00 | $80.50 | $0.00 | $560.00 | $560.00 | $640.50 | SW Gift Shop 1616 | $0.00 | $560.00 | $80.50 | DPR | XXXXX | XXXXXX-XX | $0.00 | ($560.00) | $80.50 | 20 |
| Picacho Peak | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $54,745.00 | $17,278.03 | $0.00 | $0.00 | $3,975.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $75,998.03 | $0.00 | $0.00 | $0.00 | $75,998.03 | Picacho Peak | $4,540.00 | $0.00 | $6,484.61 | $719.67 | $0.00 | $0.00 | $7,204.28 | $0.00 | $87,742.31 | $0.00 | $192.00 | $192.00 | $87,934.31 | Picacho Peak | $0.00 | $71,610.40 | $16,425.56 | DPR | 81420 | 809242-00 | $0.00 | ($71,610.40) | $16,425.56 | 21 |
| Red Rock | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $102.00 | $38,366.00 | $0.00 | $0.00 | $2,508.50 | $0.00 | $0.00 | $0.00 | $125.00 | $0.00 | $41,101.50 | $0.00 | $14.00 | $0.00 | $41,115.50 | Red Rock | $25.00 | $0.00 | $7,769.43 | $990.98 | $0.00 | $0.00 | $8,760.41 | $0.00 | $49,900.91 | $0.00 | $51.12 | $51.12 | $49,952.03 | Red Rock | $0.00 | $29,511.60 | $20,740.44 | DPR | 81260 | 809226-00 | $0.00 | ($29,511.60) | $20,740.44 | 22 |
| River Island | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $22,168.00 | $997.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $23,165.00 | $0.00 | $0.00 | $0.00 | $23,165.00 | River Island | $1,680.00 | $0.00 | $155.97 | $4.00 | $0.00 | $0.00 | $159.97 | $0.00 | $25,004.97 | $0.00 | $0.00 | $0.00 | $25,004.97 | River Island | $0.00 | $24,359.26 | $1,125.71 | DPR | 81130 | 809213-00 | $0.00 | ($24,359.26) | $1,125.71 | 23 |
| Roper Lake | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $44,130.00 | $3,887.00 | $0.00 | $0.00 | $2,100.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $50,117.00 | $0.00 | $0.00 | $0.00 | $50,117.00 | Roper Lake | $2,655.00 | $0.00 | $2,856.21 | $118.09 | $0.00 | $0.00 | $2,974.30 | $0.00 | $55,746.30 | $0.00 | $0.00 | $0.00 | $55,746.30 | Roper Lake | $0.00 | $50,107.49 | $5,588.81 | DPR | 81430 | 809243-00 | $0.00 | ($50,107.49) | $5,588.81 | 24 |
| Slide Rock | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $0.00 | $30,822.00 | $0.00 | $0.00 | $375.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $31,197.00 | $0.00 | $0.00 | $0.00 | $31,197.00 | Slide Rock | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $31,197.00 | $0.00 | $0.00 | $0.00 | $31,197.00 | Slide Rock | $0.00 | $19,750.00 | $11,497.00 | DPR | 81280 | 809228-00 | $0.00 | ($19,750.00) | $11,497.00 | 25 |
| Tombstone Courthouse | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $0.00 | $7,566.50 | $0.00 | $0.00 | $300.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $7,866.50 | $0.00 | $0.00 | $0.00 | $7,866.50 | Tombstone Courthouse | $0.00 | $0.00 | $364.20 | $0.00 | $0.00 | $0.00 | $364.20 | $0.00 | $8,230.70 | $0.00 | $0.00 | $0.00 | $8,230.70 | Tombstone Courthouse | $0.00 | $4,122.29 | $4,108.41 | DPR | 0 | 0 | $0.00 | ($4,122.29) | $4,108.41 | 26 |
| Tonto Natural Bridge | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $0.00 | $8,699.25 | $0.00 | $0.00 | $900.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $9,599.25 | $0.00 | $0.00 | $0.00 | $9,599.25 | Tonto Natural Bridge | $0.00 | $0.00 | $2,245.46 | $333.05 | $0.00 | $0.00 | $2,578.51 | $0.00 | $12,177.76 | $0.00 | $174.00 | $174.00 | $12,351.76 | Tonto Natural Bridge | $0.00 | $6,844.41 | $5,507.35 | DPR | 81290 | 809229-00 | $0.00 | ($6,844.41) | $5,507.35 | 27 |
| San Rafael | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | San Rafael | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | San Rafael | $0.00 | $0.00 | $0.00 | DPR | 0 | 0 | $0.00 | $0.00 | $0.00 | 28 |
| Granite Mountain | 12/01 - 31 2020 | 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $31.00 | $0.00 | $0.00 | $0.00 | $31.00 | $0.00 | $0.00 | $0.00 | $31.00 | Granite Mountain | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $31.00 | $0.00 | $2,014.78 | $2,014.78 | $2,045.78 | Granite Mountain | $0.00 | $300.00 | $1,745.78 | DPR | 0 | 0 | $0.00 | ($300.00) | $1,745.78 | 29 |
| Total | 0 | 0 | 0 | 0 | $791,403.21 | $250,259.78 | $18,584.00 | $21,000.00 | $129,108.50 | $5,250.00 | $583.00 | $0.00 | $370.00 | $0.00 | $1,216,558.49 | $0.00 | $274.00 | $0.00 | $1,216,832.49 | $68,548.00 | $2,664.00 | $64,403.70 | $22,865.06 | $0.00 | $0.00 | $87,268.76 | $40.00 | $1,375,353.25 | $0.00 | $3,824.48 | $3,824.48 | $1,379,177.73 | $0.00 | $1,200,082.23 | $207,554.16 | $0.00 | ($1,200,082.23) | $207,554.16 | 35 |
| $155,358.50 | Total Passes | $71,212.00 | $22,865.06 | $0.00 | 36 | ||||||||||||||||||||||||||||||||||
| $250,259.78 | Day Use/Over Short | 37 | |||||||||||||||||||||||||||||||||||||
| 38 | |||||||||||||||||||||||||||||||||||||||
| DOC NO. | DATE | CREDIT CARD | CAMPING | DAY USE | CAVE TOUR | SURCHARGE | YARNELL 4612 | $0.00 | GPR | $207,554.16 | $26,594.41 | SLRO/TONA CC Total | 39 | ||||||||||||||||||||||||||
| GPR | date | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | CHBK | $1,379,177.73 | 40 | |||||||||||||||||||||||||||
| GPR | date | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 41 | |||||||||||||||||||||||||||||
| GPR | date | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 42 | |||||||||||||||||||||||||||||
| GPR | date | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 43 | |||||||||||||||||||||||||||||
| GPR | date | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | UFAV CC ADJ TOTAL | $0.00 | UFAV CC ADJ TOTAL | 44 | ||||||||||||||||||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $26,594.41 | A.NET+SLRO+TONA+UNFAV | 45 | ||||||||||||||||||||||||||||||
| $26,594.41 | 46 | ||||||||||||||||||||||||||||||||||||||
| 47 | |||||||||||||||||||||||||||||||||||||||
| COA | TOTAL | FCC ADJ | CASH DEP | 48 | |||||||||||||||||||||||||||||||||||
| CAMPING | $791,403.21 | $0.00 | $791,403.21 | 49 | |||||||||||||||||||||||||||||||||||
| DAY USE | $250,259.78 | $0.00 | $250,259.78 | 50 | |||||||||||||||||||||||||||||||||||
| 51 | |||||||||||||||||||||||||||||||||||||||
| CAVE TOUR | $18,584.00 | $0.00 | $18,584.00 | 52 | |||||||||||||||||||||||||||||||||||
| RESERV FEES | $71,212.00 | $0.00 | $71,212.00 | 53 |
| * Request |
| Combine the sub revenues to be the revenue roll up. Do not need sub revenue break down |
Exhibit 4 - Chart of Accounts
| Reference Exhibit 5 Statwide | Reference Exhibit 5 Sub Accounts | |||
| AFIS Statewide COA # | AFIS Statewide Revenue Name | Revenue Sub Account COA | Revenue Sub Account Revenue Name | All Sales Transactions need to be labeled with the numerical and text chart of accounts at both the Statewide level and the Sub Account Level. Subtotals needed at the 4 didget Statewide Level |
| 4320 | ADMISSION AND ENTRY FEES | 4320.1 | Day Use/Entrance Fee | |
| 4320 | ADMISSION AND ENTRY FEES | 4320.11 | Day Use/Entrance Discount | |
| 4320 | ADMISSION AND ENTRY FEES | 4320.12 | Day Use/Dump Fee | |
| 4320 | ADMISSION AND ENTRY FEES | 4320.13 | Day Use/ED Spec Programs | |
| 4320 | ADMISSION AND ENTRY FEES | 4320.14 | Day Use/Commercial Passes | |
| 4323 | CONCESSIONS | 4323.1 | Concessions (Formal Contract) | |
| 4325 | CARNIVAL AND MIDWAY REVENUES | 4325.1 | Cave Tour | |
| 4325 | CARNIVAL AND MIDWAY REVENUES | 4325.11 | Cave Tour Discount | |
| 4325 | CARNIVAL AND MIDWAY REVENUES | 4325.2 | Gift Certificate Sales | |
| 4325 | CARNIVAL AND MIDWAY REVENUES | 4325.31 | Gift Certificate Discount | |
| 4325 | CARNIVAL AND MIDWAY REVENUES | 4325.9 | Non-Ref Deposit (Cave Tour) | |
| 4332 | OTHER EDUCATION FEES | 4332.1 | Other Education Fees | |
| 4339 | OTHER FEES AND CHARGES FOR SERVICCES | 4339.1 | Special Use Permit (Formal) | |
| 4339 | OTHER FEES AND CHARGES FOR SERVICCES | 4339.2 | Damage Deposit/Special Use | |
| 4339 | OTHER FEES AND CHARGES FOR SERVICCES | 4339.4 | Other Fees & Charges for Services | |
| 4372 | PUBLICATIONS AND REPRODUCTIONS | 4372.1 | Pubs Non-Taxable | |
| 4372 | PUBLICATIONS AND REPRODUCTIONS | 4372.2 | Shipping & Handling | |
| 4372 | PUBLICATIONS AND REPRODUCTIONS | 4372.3 | Gift Card Sales | |
| 4372 | PUBLICATIONS AND REPRODUCTIONS | 4372.4 | Fuel - Internal | |
| 4372 | PUBLICATIONS AND REPRODUCTIONS | 4372.41 | Fuel - External | |
| 4416 | RECREATIONAL LICENSES | 4416 | Fishing License | |
| 4432 | CAMPING PERMITS | 4432.1 | Camping | |
| 4432 | CAMPING PERMITS | 4432.1 | GCNP/FC Partnership | |
| 4432 | CAMPING PERMITS | 4432.11 | Camping Discount | |
| 4432 | CAMPING PERMITS | 4432.12 | Camping Add Vehicle | |
| 4432 | CAMPING PERMITS | 4432.2 | Cabin (also Pet Fee) | |
| 4432 | CAMPING PERMITS | 4432.21 | Cabin Discount | |
| 4432 | CAMPING PERMITS | 4432.3 | Cabin Tent Site | |
| 4432 | CAMPING PERMITS | 4432.9 | Non-Ref Deposit (Campsites) | |
| 4439 | OTHER PERMIITS | 4439.1 | Standard Pass | |
| 4439 | OTHER PERMIITS | 4439.2 | Premium Pass | |
| 4439 | OTHER PERMIITS | 4439.3 | Commercial Pass | |
| 4449 | OTHER FEES | 4449.1 | Non-Ref Reserv Fee - Cave Tour | |
| 4449 | OTHER FEES | 4449.11 | Non-Ref Reserv Fee - Rebooking | |
| 4449 | OTHER FEES | 4449.2 | Non-Ref Reserv Fee - Camp/Cabin/Cabana | |
| 4449 | OTHER FEES | 4449.3 | Non-Ref Reserv Fee - Other Facilities | |
| 4612 | RESTRICTED DONATIONS | 4612.1 | Donations - Main Park Acct | |
| 4632 | RENTAL INCOME | 4632.1 | Rental - Other Facilities | |
| 4632 | RENTAL INCOME | 4632.2 | Rental - Wedding Accessories | |
| 4632 | RENTAL INCOME | 4632.3 | Rental Income | |
| 4632 | RENTAL INCOME | 4632.9 | Non-Ref Deposit - Other Facilities | |
| 4636 | COMMISSIONS | 4636.1 | Commissions (Locker/Vending) | |
| 4699 | MISCELLANEOUS RECEIPTS | 4699.1 | Pubs Taxable | |
| 4699 | MISCELLANEOUS RECEIPTS | 4699.101 | Pubs Sales Tax | |
| 4699 | MISCELLANEOUS RECEIPTS | 4699.11 | Pubs Taxable Discount | |
| 4699 | MISCELLANEOUS RECEIPTS | 4699.2 | All Other - Misc. Revenue | |
| 4699 | MISCELLANEOUS RECEIPTS | 4699.999 | All Other - Fix and Re-Sell | |
| N/A | N/A | 1000.076 | Cash | |
| N/A | N/A | 1000.077 | Checks/Travelers Checks | |
| N/A | N/A | 2000.504 | Visa/MC | |
| N/A | N/A | 3000.505 | Conversion | |
| N/A | N/A | 3000.506 | Purchase Order | |
| N/A | N/A | 3000.507 | Gift Card | |
| N/A | N/A | 3000.508 | Phoenix Receipts/Refunds | |
| N/A | N/A | 3000.509 | To Be Resolved | |
| (blank) | (blank) | 4999.999 | Over/Short | |
| (blank) | (blank) | (blank) | (blank) | |
| Grand Total |
Exhibit 5 Chart of Accounts
Statewide Chart of Accounts State Accounting System Reports on Statewide COAs (External Reporting and Banking) Revenue Sub Accounts For Internal Detailed Revenue Reporting
Exhibit 6 Audit Report for Surc
| Date of Reservation (Search Range) | ||||
| Reservation Type | # of Reservations | Reservation Surcharge Collected $ | # of Reservations Surcharge Refunded | Refunded Surcharge Revenue $ |
| Cabin | 1000 | $10,000 | 2 | $20 |
| Camping | 25000 | $125,000 | 3 | $15 |
| Ramada/Other | 100 | $500 | 1 | $5 |
| Tours | 2000 | $6,000 | 2 | $6 |
| Total By Type | 28100 | $141,500 | 8 | $46 |
| This report shows reservation surcharge revenue generated during a specified period or date range. |
Exhibit 7 Audit Report for Surc Date of Reservation (Search Range)
| Park | Cabin Reservation Transactions # | Cabin Reservation Surcharge Collected $ | Cabin Reservation Surcharge Transaction Refunds # | Cabin Reservation Surcharge Transaction Refunds $ | Camping Reservation Transactions # | Camping Reservation Surcharge Collected $ | Camping Reservation Surcharge Transaction Refunds # | Camping Reservation Surcharge Transaction Refunds $ | Ramada/Other Reservation Transactions # | Ramada/Other Reservation Surcharge Collected $ | Ramada/Other Reservation Surcharge Transaction Refunds # | Ramada/Other Reservation Surcharge Transaction Refunds $ | Tours Reservation Transactions # | Tours Reservation Surcharge Collected $ | Tours Reservation Surcharge Transaction Refunds # | Tours Reservation Surcharge Transaction Refunds $ |
| Alamo Lake | 4 | $40 | 1 | $10 | 4 | $20 | 1 | $5 | 4 | $20 | 1 | $5 | 4 | $12 | 1 | $3 |
| Buckskin Mountain | 4 | $40 | 0 | $0 | 4 | $20 | 0 | $0 | 4 | $20 | 0 | $0 | 4 | $12 | 0 | $0 |
| Catalina | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| Cattail Cove | 4 | $40 | 0 | $0 | 4 | $20 | 0 | $0 | 4 | $20 | 0 | $0 | 4 | $12 | 0 | $0 |
| Dead Horse Ranch | 4 | $40 | 0 | $0 | 4 | $20 | 0 | $0 | 4 | $20 | 0 | $0 | 4 | $12 | 0 | $0 |
| Fool Hollow Lake | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| Fort Verde | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| Homolovi | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| Jerome | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| Kartchner Caverns | 5 | $50 | 0 | $0 | 5 | $25 | 0 | $0 | 5 | $25 | 0 | $0 | 5 | $15 | 0 | $0 |
| Lake Havasu | 13 | $130 | 0 | $0 | 13 | $65 | 0 | $0 | 13 | $65 | 0 | $0 | 13 | $39 | 0 | $0 |
| Lost Dutchman | 5 | $50 | 0 | $0 | 5 | $25 | 0 | $0 | 5 | $25 | 0 | $0 | 5 | $15 | 0 | $0 |
| Lyman Lake | 8 | $80 | 0 | $0 | 8 | $40 | 0 | $0 | 8 | $40 | 0 | $0 | 8 | $24 | 0 | $0 |
| Oracle | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| Patagonia Lake | 5 | $50 | 0 | $0 | 5 | $25 | 0 | $0 | 5 | $25 | 0 | $0 | 5 | $15 | 0 | $0 |
| Central Office (Park Store) | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| Picacho Peak | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| Red Rock | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| River Island | 5 | $50 | 0 | $0 | 5 | $25 | 0 | $0 | 5 | $25 | 0 | $0 | 5 | $15 | 0 | $0 |
| Roper Lake | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| Slide Rock | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| Tombstone Courthouse | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| Tonto Natural Bridge | 1 | $10 | 0 | $0 | 1 | $5 | 0 | $0 | 1 | $5 | 0 | $0 | 1 | $3 | 0 | $0 |
| San Rafael | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| Granite Mountain | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
| Total | 58 | $580 | 1 | $10 | 58 | $290 | 1 | $5 | 58 | $290 | 1 | $5 | 58 | $174 | 1 | $3 |
image1.png
File details come from the government source that posted it. Updated .