Trial Balance by Accounting Distribution (A611) Metadata

Abstract

This dataset contains the detail trial balance for the City of Ann Arbor for fiscal year 2010.  The report is organized by Fund, Agency, Organization and Activity and lists the transactions posted to each account for all accounts of the City. This report is updated monthly. The Accounting Services Unit is part of Financial and Administrative Services Area. For information about specific transactions, please contact the person listed below.

Point of contact

Karen Lancaster, Accounting Services Manager100 North Fifth Avenue
Ann Arbor, MI 48104
734-794-6000 ext. 4-5209
Fax: 734-994-2777
Email: klancaster@a2gov.org
Hours: Monday to Friday 8am-5pm

Data accuracy

 This report is a download from the City’s financial system.

Entity

N/A

Attributes

• Transaction ID
  The alphanumeric number assigned to the transaction.​
• ​​​Tran Date
  The date associated to the transaction.
• Vendor/Provider
  The vendor # or customer # (if any) associated with the transaction.
• Sub Org
  Not used.
• Sub-Obj/Rev Src
  Not used for sub-obj. Used as Sub Rev Src to further delineate transactions within a revenue source.
• Job Number
  The job number assigned to the transaction. This is used for project accounting.
• Rept Catg
  Not used.
• Internal Ref
  Not used.
• Description
  The description of the transaction as entered into the financial system.
• Total Debits
  This is the total amount of debits for the account for the month.
• Total Credits
  This is the total amount of credits for the account for the month.
• Ending Balance
  This is the balance of the account at the end of the month.
• Account Type
  This code reflect the type of balance sheet item represented. 01 is Assets, 02 is Liabilities, 03 is Fund Balance, 21 is Encumbrances (outstanding purchase orders), 22 is Expenditures and 31 is Revenues.
• B.S. Acct
  This is the four-digit numeric code and name associated with the balance sheet account in the City’s financial system.
• Obj/Rev Source
  This is the four-digit numeric code and name associated with the object and revenue accounts in the City’s financial system. ​