Event 1 Liberty Reports for Sage Master Builder
Trial Balance Instructions
5/3/2013 8:01 AM
Example Name
Trial Balance.xlt
Purpose
This report produces a standard trial balance for the desired period in the current fiscal year. The account list can be quickly filtered using the auto-filter drop-down buttons that appear above each column caption. NOTE - This workbook has been converted to static values and contains no links to live data that can be refreshed.
More Like This
For information about more templates like this one, contact us at:
[email protected]
Before You Start
Macros are presently enabled Some of the functionality functionali ty of this workbook is provided by Excel macros. To learn more about macro security, click th following link. http://kb.event1software.com/questions/45
Requirements
Using This Example
1. Click the Trial Balance worksheet 2. Enter the desired period number in the Period cell. 3. Click Refresh on the Liberty Reports toolbar to see current values. 4. Optionally - Filter the list of accounts by clicking clicki ng the drop-down drop-down button that appears on a given column caption. For example, the account list can be quickly filtered to show only certain types of accounts that you want to see.
Event 1 Liberty Reports for Sage Master Builder Sage Master Builder
Not sure where to start? Use the "Sample Company" data folder provided with your Sage Master Builder software and use the "Sample Values" worksheet for guidance. Disclaimer
This template is provided as an example. Use of it results in a live connection to your Sage Master Builder database. We suggest testing this template with your your data before determining its suitability for your business needs. Your review process may need to involve your Sage Master Builder consultant and your representative for services pertaining to Event 1 Software products.
About the Design
A single query query drives most most of the information information in this report. report. The query query includes the account number, title, beginning balance for the year, and period amounts for periods 1 to 12. Most of these columns are hidden. Formulas in adjacent columns determine which values to show in order to reflect the current period activity and current balance.
Revision Number
Revision 1 Saturday, November 07, 2009 at 1:38 PM
\\vboxsrv\conversion_tmp\scratch_3\143236708.xls.ms_office
Page 1 of 4
Event 1 Liberty Reports or Sage Master Builder
5/3/2013 8:01 AM
Trial Balance
Managed Rite Construction C:\MB7\Sample Company Fiscal Year: 6/29/1905 Period:
Account 1000 1002 1003 1010 1020 1120 1180 1190 1200 1250 1260 1420 1430 1590 1800 1810 1820 1840 1860 1900 1910 1920 1940 1960 2000 2200 2300 2301 2302 2303 2308 2311 2500 2510 2800 2810 3000 3300 4000 4090 4200 4400 5001 5003 5004 5005 5400 5401 5402 5403 5404 5405 5750 5800 6000 6001 6002 6003 6004 6005 6006 6007
Account Title General Checking Payroll Checking Field Checking Petty Cash Savings Contract Receivables Bad Debt Allowance Underbillings (Inventory) Plan Deposits Refundable Deposits PPD Liability Insurance Work Comp Deposit Note Receivable - Shareholder (Heavy Equipment) Vehicles Shop Equipment & Tools Office Equipment Furniture & Fixtures (Accum Dep'n Heavy Equipment) Accum Dep'n Vehicles Accum Dep'n Shop Eq/Tools Accum Dep'n Office Equipment Accum Dep'n Furniture & Fxt Trade Accounts Payable Sales Tax Payable Fica/FIT Payable State Payroll Taxes Payable Workers' Compensation Payable Futa Payable Child Support Payable 401K Payable Corporate Federal Tax Payable Corp State Income Tax Payable (Heavy Equipment Loan) Vehicle Loans Capital Stock Retained Earnings Contract Income Discounts Given Interest Income Discounts Earned Material Equipment Expense Subcontracted Other Job Expense Direct Labor D/L Payroll Taxes D/L Workers' Compensation D/L Benefits D/L Liability Insurance D/L Small Tool Exp (Equipment Repair) (Equipment Use Contra) Rent Office Supplies Utilities Telephone Cell Phone / Paging Bank Charges Postage & Freight Janitorial
Type Cash Account Cash Account Cash Account Cash Account Cash Account Current Asset Current Asset Current Asset Current Asset Current Asset Current Asset Other Asset Other Asset Other Asset Fixed Asset Fixed Asset Fixed Asset Fixed Asset Fixed Asset Depreciation Depreciation Depreciation Depreciation Depreciation Current Liability Current Liability Current Liability Current Liability Current Liability Current Liability Current Liability Current Liability Current Liability Current Liability Longer Term Liability Longer Term Liability Equity Equity Operating Income Operating Income Operating Income Operating Income Direct Expense Direct Expense Direct Expense Direct Expense Direct Expense Direct Expense Direct Expense Direct Expense Direct Expense Direct Expense Equip/Shop Expense Equip/Shop Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense
\\vboxsrv\conversion_tmp\scratch_3\143236708.xls.ms_office CONFIDENTIAL
Beginning Balance 76,071.02 1,488.79 302.86 300.00 27,113.18 711,589.67 (15,000.00) 15,795.21 9,475.40 450.00 1,900.00 2,892.02 5,725.00 10,000.00 74,081.00 109,377.85 42,845.64 45,523.30 19,960.21 (47,719.53) (68,291.16) (24,071.00) (29,383.00) (13,610.00) (242,293.91) (5,540.55) (4,693.81) (2,490.42) (339.64) (580.00) (3,459.81) (52,458.47) (23,480.70) (19,103.78) (45,813.71) (25,000.00) (49,245.16) (1,460,534.07) (1,145.22) 324,028.37 2,121.50 460,700.65 1,180.05 75,560.98 11,572.59 9,267.42 20,169.67 4,834.25 1,315.00 2,017.69 (294.00) 7,600.00 7,771.09 460.22 1,309.80 1,862.83 210.00 686.75 765.00
Period Activity 6,762.07 (454.71) 125,000.00 (71,927.54) (2,471.39) (739.06) (1,157.69) (444.75) (470.75) (222.25) (232,585.26) 502.36 (296.03) (4,365.76) (288.32) 20.00 (2,714.03) 371.98 756.94 (479,419.58) 212.02 192,372.44 3,053.50 242,263.20 396.92 42,143.84 6,036.81 6,320.31 13,290.46 2,960.56 918.50 650.00 (1,871.00) 1,900.00 611.15 94.66 285.98 624.82 300.00 270.00
5 Ending Balance 82,833.09 1,034.08 302.86 300.00 152,113.18 639,662.13 (15,000.00) 15,795.21 9,475.40 450.00 1,900.00 420.63 5,725.00 10,000.00 74,081.00 109,377.85 42,845.64 45,523.30 19,960.21 (48,458.59) (69,448.85) (24,515.75) (29,853.75) (13,832.25) (474,879.17) (5,038.19) (4,989.84) (6,856.18) (627.96) (560.00) (6,173.84) (52,458.47) (23,480.70) (18,731.80) (45,056.77) (25,000.00) (49,245.16) (1,939,953.65) 212.02 (1,145.22) 516,400.81 5,175.00 702,963.85 1,576.97 117,704.82 17,609.40 15,587.73 33,460.13 7,794.81 2,233.50 2,667.69 (2,165.00) 9,500.00 8,382.24 554.88 1,595.78 2,487.65 210.00 986.75 1,035.00
Page 2 of 4
Event 1 Liberty Reports or Sage Master Builder
5/3/2013 8:01 AM
Trial Balance
Managed Rite Construction C:\MB7\Sample Company Fiscal Year: 6/29/1905 Period:
Account 6008 6010 6011 6015 6020 6025 6026 6028 6030 6100 6110 6120 6999 6220 6400 6401 6402 6403 6404 6500 6520 6600 6810 7400 7401 7403 6395 1225 1121 6022 5710 5720 2325 5604 1125 2001 3499 1845 5780 4010 4005
Account Title Advertising & Promotion Accounting Fees Legal Fees Consulting Fees Travel, Meals Dues & Subscriptions Continuing Education Charity Donations Maintenance & Repair General Insurance Taxes & Licenses Interest Expense Suspense/clearing Warranty Work Overhead Labor O/H Payroll Taxes O/H Workers' Compensation O/H Benefits O/H Liability Insurance Vehicle Expenses Vehicle Fuel Small Tools/Shop Supplies Depreciation Expense Admin Salaries Admin Payroll Taxes Admin Benefits Estimating Labor Prepaid Health Ins AR - Startup Entertainment Equipment Interest Expense Equipment Depreciation Expense Line of Credit Payable Shop Liability Ins (Service) AP - Startup Startup Clearing Software Equipment Fuel Resale Service Income
Type Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Overhead Expense Administrative Expense Administrative Expense Administrative Expense Overhead Expense Current Asset Current Asset Overhead Expense Equip/Shop Expense Equip/Shop Expense Current Liability Equip/Shop Expense Current Asset Current Liability Equity Fixed Asset Equip/Shop Expense Operating Income Operating Income
Report Totals
\\vboxsrv\conversion_tmp\scratch_3\143236708.xls.ms_office CONFIDENTIAL
Beginning Balance 1,044.85 6,450.00 250.00 4,863.86 439.90 225.00 700.00 1,213.12 1,037.87 953.58 1.84 37,740.00 3,924.60 1,713.26 4,981.00 998.92 2,892.47 5,102.01 786.53 9,181.76 26,153.82 3,108.48 2,879.46 14,960.00 1,645.19 3,564.88 667.54 2,956.24 (110,000.00) 15,786.75 -
Period Activity 990.00 580.00 175.00 1,200.00 784.27 395.00 800.00 500.00 423.29 375.00 1,350.61 11,460.03 1,221.74 535.87 1,493.80 315.83 737.88 853.24 56.96 3,034.50 7,692.30 588.45 846.90 4,400.00 45.30 197.37 159.26 110,000.00 97.00 -
5 Ending Balance 2,034.85 7,030.00 425.00 1,200.00 5,648.13 834.90 1,025.00 1,200.00 1,636.41 375.00 1,037.87 2,304.19 1.84 49,200.03 5,146.34 2,249.13 6,474.80 1,314.75 3,630.35 5,955.25 843.49 12,216.26 33,846.12 3,696.93 3,726.36 19,360.00 1,690.49 3,762.25 826.80 2,956.24 97.00 15,786.75 -
Page 3 of 4
Event 1 Liberty Reports for Sage Master Builder
Trial Balance Sample Values
5/3/2013 8:01 AM
Try this template using the "Sample Company" and the following values:
Parameter Values Trial Balance Period
5
\\vboxsrv\conversion_tmp\scratch_3\143236708.xls.ms_office
Page 4 of 4
