basic accounting principlesuniversity of california

1、Balance Sheet Account Reconciliation TutorialGeneral Accounting - June 20151. Definition of a Reconciliation 2. Importance of a Reconciliation 3. When to Prepare a Reconciliation4. Items Needed to Prepare a Reconciliation5. Key Terms6. Example of a Reconciliation7. Reconciliation Instructions8. Appr

2、oval and Submission9. FAQsTable of ContentsIn accounting, Reconciliation refers to the process of ensuring that two sets of records are in agreement. Reconciliation is used to ensure that the transactions going through an account match the actual money spent. The objective is to report the correct a

3、mount in the general ledger. This is done by making sure the balances match at the end of a particular accounting period.For example, we reconcile the balance in the general ledger account”Cash “ to the balance shown on the bank statement. Definition of a ReconciliationTwo Records - A proper reconci

4、liation requires obtaining all of the activity in two records (department sub-ledger and the general ledger) since the last time they were reconciled and comparing them to find where any difference(s) occur. Difference in Two Records - A difference between the two records can highlight a posting err

5、or within your department; internal entities, such as Payroll or Disbursements; external entities, such as the bank or loan company; or even something much more significant: fraud.Importance of a ReconciliationTimeliness- It is best practice to reconcile an account monthly, following month-end close

6、.If the account has been reconciled monthly, then only the activity in the last month must be reconciled.If the account has not been reconciled monthly, you will need to reconcile back to the last month that it had been reconciled. If you cannot locate a reconciliation for the account, you should co

7、mplete a reconciliation for the current fiscal year.Reconciliations are much easier to do, and differences are easier to resolve, if they are done monthly. Doing reconciliations monthly will save time and effort and any corrective action can be taken to resolve issues.Submission - General Accounting

8、 requires balance sheet account reconciliations be submitted on a quarterly basis.When to Prepare a ReconciliationAccess to:1. FinancialLink make sure you are set up with an access login through your departments DSA (Departmental Security Administrator).Items Needed to Prepare a Reconciliation 2. Mi

9、crosoft Excel3. Departments Sub-ledgersKey Terms 1 of 3Balance Sheet Reconciliation is a template in which data from a balance sheet account is entered from the DepartmentBalance Sheet Accounts are used in the general ledger and represent the assets and liabilities of the University.Asset accounts s

10、tart with 1, and liability accounts start with 2. Sub-ledger and the General Ledger in order to analyze and identify any differences.Key Terms 2 of 3B General Ledger is a record of financial transactions at UCSD used to produce financial reports, such as a balance sheet and income statement.Example:

11、 A key deposit account should have a sub-ledger that lists all outstanding deposits by amount, name, and date.A Department Sub-ledger refers to the sub-system, list, record, external statement, etc. maintained by a department detailing the balance in the account. Key Terms 3 of 3D Reconciling Items

12、are any items from the A Department Sub-ledger and B General Ledger that do not match. These items need to be researched to ensure they are legitimate and will be matched in a future month. Any errors need to be corrected.C Variance is any difference(s) between items listed on a A Department Sub-led

13、ger and the B General Ledger.Example of a Reconciliation A proper reconciliation is comprised of four parts:A Dept Sub-ledger Account BalanceB General Ledger BalanceC VarianceD Reconciling ItemsItems on the A Dept Sub-ledger are matched against the items on the B General Ledger.The C Variance should

14、 be zero.Any remaining items that are not matched are classified as D Reconciling Items. Reconciliation Instructions Take items from your dept sub-ledger and enter them into the section of the reconciliation sheet called A Dept Subledger Account Balance. Reconciliation Instructions Step 1Reconciliat

15、ion Instructions Step 21. Log into FinancialLink.2. Click Reports.Next, get the account balance per the General Ledger in FinancialLink. Recommended: do not limit your search to only one fund. Reconciliation Instructions Step 2(contd)3. Click the dropdown arrow next to Ledger and Detail Reports.4. C

16、lick General Ledger.Reconciliation Instructions Step 2 (contd)5. Update the accounting period to reflect the period you are reconciling.6. Type the Account #.7. Click Submit Form.Recommended: Check the boxes to see Db/Cr Indicators.Take the balance from the general ledger report and enter it into se

17、ction B General Ledger Balance on the reconciliation sheet.Reconciling Instructions Step 3Analyze section C Variance between the A Dept Sub-ledger and the B General Ledger. Is the variance zero? If so, you are done!Reconciliation Instructions Step 4If the C Variance is NOT zero, you need to identify

18、 the D Reconciling Items. These items can be journal entries not recorded in that period in FinancialLink or timing differences that will clear in future months. After the reconciling items have been identified, Unreconciled Balance should be zero. Once the reconciliation(s) are completed, the recon

19、ciliation must be verified and approved.The review and approval is typically performed by a supervisor to verify that the reconciliation meets the standard as outlined.A link to the form is included in the email you receive from the Balance Sheet Coordinator. If you are unable to locate that link, g

20、o to Blink and search for Confirmation of Balance Sheet Account. A new form is posted for each quarter.Type directly into this document, then save and print.Approval & Submission 1 of 3Approval & Submission 2 of 3 Type the Account information - number and title.The next portion is for the Reconcilia

21、tion Preparer and Supervisor signatures. By signing the form, you agree that the reconciliations are complete and accurate. Please note that for audit purposes, the Preparer and Supervisor (Approver) need to be two different people.The bottom of the form reminds you where to submit your reconciliati

22、on(s).You can submit one confirmation form for multiple account reconciliations provided the account numbers are all listed on the form in the proper location and all reconciliation supporting documentation is attached.Approval & Submission 3 of 3 Please send all submissions to: Make sure to submit

23、a copy of the reconciliation for each account named on the form as supporting documentation.Question: Who should do the reconciliation?Answer: This varies from department to department. The person responsible for updating the General Ledger (and/or keeping the department schedule up to date) should

24、NOT be the same person performing the reconciliation.Question: The worksheet I receive each quarter listing the accounts and owners is incorrect or incomplete.Answer: Please email with the necessary corrections. Please correct the worksheet and send it back, with corrections highlighted in yellow. F

25、AQs 1 of 3Question: I receive the worksheet each quarter asking for a reconciliation, but the account has a zero balance.Answer: A certification should still be sent to General Accounting stating the account has the correct balance, in this case, zero. If the account has activity within the quarter even with a zero balance, a reconcilia