Question

In: Accounting

how to make general ledger, bank reconciliation

how to make general ledger, bank reconciliation

Solutions

Expert Solution

Bank reconciliation steps

  1. Get bank records. You need a list of transactions from the bank. ...
  2. Get business records. Open your ledger of income and outgoings. ...
  3. Find your starting point. ...
  4. Run through bank deposits. ...
  5. Check the income on your books. ...
  6. Run through bank withdrawals. ...
  7. Check the expenses on your books. ...
  8. End balance.

How Do I Create a General Ledger?

1. Create the chart of accounts. Most accounting systems have five sections for the chart of accounts. Asset accounts begin with a "1," liabilities start with "2," owner's equity starts with "3," revenues are "4" and expenses are "5." For example, the account Cash could be assigned 101, accounts payable 202, retained earnings, 301. Smaller businesses start with 100, while larger businesses and corporations generally use 1000 as their starting account numbers.

2. Create an entry for each account created in Step 1. Each account identified in the chart of accounts should have its own page for transactions. Giving each account a separate page makes adding and deleting accounts easier. The accounts should be entered into the ledger in the same numerical order assigned in the chart of accounts.

How to make general ledger, bank reconciliation

Quick Steps. Create GL entries for any bank fees or other charges that are included in the bank statement but not previously entered in Unanet. This must be completed before reconciling the statement. Navigate to Financials > General Ledger > Bank Reconciliation > +Bank Reconciliation Icon.

Reconciling Bank Accounts in General Ledger

Reconciling the bank account by comparing your bank statement to the General Ledger accounts ensures the account is in balance for the reconciliation period. You can enter and post service charges or interest while reconciling transactions, and you can reconcile the bank account at any time. To sort the reconciliation window based on a particular column, click the column header.

If you have used the ACS Bank Reconciliation feature, the Reconcile from date and Previous Stmt Bal fields are already completed (If this is your first time reconciling, be sure to enter the Last Statement Balance in Define Lists).

When reconciling, you'll print the bank reconciliation report, which you can store with your bank files. This report displays the total withdrawals and deposits, and you can include cleared or uncleared transactions on the report. If you include both cleared and uncleared transactions, the transactions for each are listed separately with their own totals.

You can also print all cleared and uncleared items together by clearing the Page Break on Transaction Status option. If you want to compare reports or see differences, you can also print the Bank Account Journal in General Ledger Reports.

.


Related Solutions

The Scooter Warehouse provided the following information at December 31, 2013:   Bank Reconciliation   General ledger cash...
The Scooter Warehouse provided the following information at December 31, 2013:   Bank Reconciliation   General ledger cash        balance, 12/31/13 $ 17,566   Bank statement balance,        12/31/13 $ 16,306   Bank service charge (25 )   Deposits in transit 2,450   Returned customer checks        marked NSF (375 )   Outstanding checks (1,356 )   Error in recording of office      supplies 234   Adjusted cash balance,       12/31/13 $ 17,400   Adjusted cash balance,       12/31/13 $ 17,400 Investment in securities The company invested $26,000 in a portfolio of investment in securities on...
The Ski Factory provided the following information at December 31, year 1. Bank Reconciliation General ledger...
The Ski Factory provided the following information at December 31, year 1. Bank Reconciliation General ledger cash balance, 12/31/year 1 $ 35,132 Bank statement balance, 12/31/year 1 $ 32,612 Bank service charge (50 ) Deposits in transit 4,900 Returned customer checks marked NSF (750 ) Outstanding checks (2,712 ) Error in recording of office supplies 468 Adjusted cash balance,12/31/year 1 $ 34,800 Adjusted cash balance,12/31/year 1 $ 34,800 Marketable Securities: The company invested $52,000 in a portfolio of marketable securities...
General and Subsidiary Ledger Entries; Reconciliation The City of Beverly Heights General Fund had the following...
General and Subsidiary Ledger Entries; Reconciliation The City of Beverly Heights General Fund had the following transactions, among others, in 20X7: 1. Appropriations were made as follows: Personal Services $111,400 Contractual Services 8,700 Materials and Supplies 8,500 New Patrol Cars 21,000 Other 12,000 $161,600 2. General Fund cash, $2,000, was paid to a Debt Services Fund to provide for debt service. 3. A long-term note of $8,300, including interest of $1,300, and a short-term note of $2,500 (including $150 interest)...
a) Approval of bad debt write-offs and the reconciliation of accounts receivable subsidiary ledger and the general ledger control account.
  Explain why each of the following combinations of tasks should or should not be separated to achieve adequate internal control: a) Approval of bad debt write-offs and the reconciliation of accounts receivable subsidiary ledger and the general ledger control account. b) Distribution of payroll cheques to employees and approval of employee time cards. c) Posting of amounts from both the cash receipts and the cash disbursements journals to the general ledger. d) Writing cheques to suppliers and posting to...
True or False. All items shown on the bank reconciliation as adjustments of the book (ledger)...
True or False. All items shown on the bank reconciliation as adjustments of the book (ledger) balance require journal entries to adjust the Cash account, whereas items appearing as adjustments to the balance per bank statement do not require entries by the depositor. Answer should be: FALSE Please explain
What journal entries do accountants do everyday? What is general ledger reconciliation? How do you reconcile...
What journal entries do accountants do everyday? What is general ledger reconciliation? How do you reconcile the general ledger (explain the steps from a real company perspective)? Why do accountants need to do journal entries when accounting software can automatically create journal entries? What are daily adjusting entries and give an example?
The bank statement ending balance is $45 lower than the general ledger bank balance....
The bank statement ending balance is $45 lower than the general ledger bank balance. On the bank statement, there is a line item for bank charges and fees of $45.  How should the adjustment be recorded in the general ledger?  SELECT ONLY ONE  Debit Bank Fees Expense $45 Credit Retained Earnings $45  Debit Bank Fees Expense $45 Credit Bank Account $45  Debit Bank Account $45 Credit Retained Earnings $45  Debit Retained Earnings $45 Credit Bank Account $45  Debit Bank Account...
Items on a Bank Reconciliation Assume that a company is preparing a bank reconciliation for the...
Items on a Bank Reconciliation Assume that a company is preparing a bank reconciliation for the month of June. It reconciles the bank balance and the book balance to the correct balance. For each of the following items, indicate whether the item is an addition to the bank balance, an addition to the book balance, a deduction from the bank balance, a deduction from the book balance, or would not appear on the June reconciliation. Also, choose Yes or No...
Prepare bank reconciliation and related entries. AP The bank portion of the bank reconciliation for Katsaris...
Prepare bank reconciliation and related entries. AP The bank portion of the bank reconciliation for Katsaris Company at August 31, 2017, was as follows: KATSARIS COMPANYBank Reconciliation August 31, 2017 Cash balance per bank $13,229 Add: Deposits in transit 2,350 15,579 Less: Outstanding cheques #4451 $1,740 #4460 549 #4461 723 #4462 1,840 #4464 620 5,472 Adjusted cash balance per bank $10,107 The unadjusted cash balance per books on September 30, 2017, was $10,228. The September bank statement showed the following:...
Question What is bank reconciliation? What is the objectives of the bank reconciliation statement?
Question What is bank reconciliation? What is the objectives of the bank reconciliation statement?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT