Bank Reconciliation: Difference between revisions

From Jewel
Jump to navigation Jump to search
No edit summary
 
(25 intermediate revisions by the same user not shown)
Line 3: Line 3:
Best practice is to reconcile monthly before closing the month. This allows you to catch mistakes or omissions when they are easiest to correct. However, if you cannot reconcile during your month-end closing for some reason, you may do so at any point during the monthly process of any future month by clicking Reconcile on the Jewel Home Screen. Keep in mind, though, that postponing or skipping reconciliation means that your Jewel records may not accurately reflect what has happened at the bank. Also, there is usually a strict time frame for reporting fraudulent transactions. So reconciliations should always be completed as soon as possible after receiving the bank statement.
Best practice is to reconcile monthly before closing the month. This allows you to catch mistakes or omissions when they are easiest to correct. However, if you cannot reconcile during your month-end closing for some reason, you may do so at any point during the monthly process of any future month by clicking Reconcile on the Jewel Home Screen. Keep in mind, though, that postponing or skipping reconciliation means that your Jewel records may not accurately reflect what has happened at the bank. Also, there is usually a strict time frame for reporting fraudulent transactions. So reconciliations should always be completed as soon as possible after receiving the bank statement.


[[Media:3505_-_Bank_Recs_-_Why_They_Are_Such_a_Big_Deal.pdf|Here's why bank recs are such a big deal!]]
The links below will answer your Bank Reconciliation-related questions.


==Basic Steps==
==Basic Info and Quick Start==
Here are the steps to follow when performing your Bank Reconciliation:
[[Why Are Bank Recs Important?]]
# On the Jewel Home Screen, click the NextStep button when it says Reconcile Bank Statements, or click Reconcile.
# You will see a list of accounts waiting to be reconciled. Those that still need to be reconciled this month will be in bold. Note that you can adjust the Statement Frequency for each bank account in Maintenance / [[Edit Accounts#Edit an Account|Edit Accounts]] (and Never is an option, if you no longer wish the account to appear here).
# Double-click on the account you are reconciling, or select the account and click Reconcile.


Now take a moment to familiarize yourself with the Bank Reconciliation screen. At the top left is a box with information that should match your Bank Statement. Under that is a list of Deposits and a list of Checks that have been recorded in Jewel. Only transactions up to the Ending Date are shown here. If you wish to see later transactions, click "Show More Deposits" or "Show More Checks", just above each list.
[[Quick Start Guide to Bank Reconciliations]]


Back at the top, toward the right, is the "Balances" box. The top number matches your Bank Beginning Balance. The next two numbers give the totals of the items you have checked off in Jewel. The Cleared Ending Balance is calculated by adding the deposits to the Cleared Beginning Balance and then subtracting the checks. Your goal is to make the Cleared Ending Balance match the Bank Ending Balance. When it does, the Difference at the bottom of that box will be $0 and your Bank Reconciliation will be completed.
[[Quick Start - Adding Missing Transactions]]


The Add Entry box at the bottom contains shortcuts for entering interest, bank fees, corrections, and other forgotten entries. Keep reading for instructions on how to use them.
[[Making Corrections|Chapter 7: Making Corrections]]


And lastly, the row of buttons at the top right contains a button to print your reconciliation-in-progress (sometimes seeing it on paper can help find mistakes), your deposit, check, and bank rec reports (all useful for finding transactions), and [[Media:3680_-_Undo_Last_Reconciliation_-_When_and_How.pdf|Undo Last Reconciliation]]
[[Media:3510_-_Tour_of_the_Reconcile_Features_in_Jewel.pdf|Pictorial Tour of Jewel's Bank Reconciliation]]


Now let's continue:
==Reconciling Specific Types of Accounts==
# Look at your Bank Statement and find the Ending Date. Make sure it matches the Ending Date pre-filled in Jewel. If the difference is only a few days, correct the date in Jewel. If Jewel's date is in the wrong month, figure out why by looking at Previous Bank Recs or contact technical support for help. (Note that you can change the
[[Reconciling the Checking Account]]
# Look at your Bank Statement and find the Beginning Balance for this period. Make sure that it matches the Beginning balance pre-filled in Jewel. If not, contact technical support for help.
# Look at your Bank Statement and find the Ending Balance for this period. Enter this amount in the Ending text box.
# Compare the transactions on your Bank Statement to the transactions in Jewel. Every transaction on your bank statement should be recorded in Jewel, exactly as it appears on your bank statement. Work your way down the bank statement, matching each transaction with a corresponding transaction in Jewel, and checking off each transaction in Jewel as you find it.
#If a transaction should match but doesn't, then Jewel must be corrected. Follow the link to instructions for [[Making Corrections|specific corrections here]], noting that the Bank Reconciliation screen has shortcuts to the Check and Deposit reports, to Write Checks, and to Make General Journal entry, which can help make corrections faster.
# If a transaction on the bank statement is missing from Jewel, it must be added. Follow the link to instructions for [[Bank Reconciliation#Adding Missing Transactions|adding missing transactions here]].
# When you have checked off a corresponding entry in Jewel for each and every transaction on the bank statement, the Difference in Jewel (just above the sunset picture) will be $0.00. Click OK to complete the Bank Reconciliation and print your Bank Reconciliation Report.
# Repeat for each bank account needing reconciliation. Then click Finished All Bank Reconciliations to proceed to the next step.


If you wish to leave the reconciliation at any point before reaching a Difference of $0.00, click Cancel, then Yes to save your work.
[[Media:3530_-_Reconciling_the_Debit_Account.pdf|Reconciling the Debit Account]]


[[File:Bank_Reconciliation_screen.png|center|600px]]
[[Media:3540_-_Reconciling_the_Savings_Acct.pdf|Reconciling the Savings Acct]]


[[Media:3510_-_Tour_of_the_Reconcile_Features_in_Jewel.pdf|Here's a pictorial tour of Jewel's bank reconciliation.]]
[[Setting Up and Reconciling a CD Account]]


==Adding Missing Transactions==
First click "Show More Deposits" or "Show More Checks" to see if the transaction was recorded outside of the reconciliation date range. If you see it, check it off, then click OK to return to the regular reconciliation screen. You can also access your Check Report and Deposit Reports from the Bank Rec screen, where it may be easier to search for the transactions. Be very sure that the transaction is truly missing before adding a new one, as double entries will make your books inaccurate.


====Interest earned====
Click "Interest Earned or Deposit Correction". Fill in the abbreviated General Journal form, including the Local Fund to credit the interest to. Many small churches simply credit the interest to Church Budget. Larger churches may wish to create a specific fund to track interest income. Click Add Entry to finish.


====Bank Fees====
[[Electronic Payments - Timing, Dates, Memos]]
Click "Bank Fees or Check Correction". Fill in the abbreviated General Journal form, including the Local Fund to charge the fee to. Most churches will charge fees to Church Budget or to a separate Bank Fees fund if they wish to track more closely. Click Add Entry to finish.


====Offering Deposits====
==Troubleshooting==
Cancel out of the bank reconciliation (click Cancel, then Yes to save your work) back to the Jewel home page.
[[Where Did My Reconciliation Go?]]


If the NextStep button says Start New Offering, then enter the missing offering as usual. If the NextStep button says Remit to Conference, go to Offerings (at the top of the page), then Start New Offering, and enter the offering as usual.
<br><br>
-----
[[The Basic Jewel Processes|Return to Chapter 3: The Basic Jewel Processes]]


If the NextStep button says anything else, contact tech support for assistance. Or you can wait to finish the reconciliation and enter the offering in the next month, as long as it will still be in the same calendar year. It's OK, although not best practice, to enter a July  offering on August 1. It is not acceptable to enter a December offering in January, per IRS regulations.
[[Budget|Continue to Chapter 5: Budget]]
 
====Non-offering deposits====
Click General Journal Entry (below the picture). Fill in the memo to indicate the source of the funds and any other pertinent information. Fill in the amount of income, and the Local Fund(s) that the income should be credited to. Click OK to finish and return to the reconciliation.
 
====Checks or other payments====
Click Write Checks (below the picture). Fill out the check form as usual (clicking Electronic Payment if appropriate). Click OK to finish and return to the reconciliation.
 
Note that checks and other payments should <strong>not</strong> be entered as General Journal entries, or via "Bank Fees and Check Corrections". [[Media:3620_-_General_Journal_Entry_Use_During_Reconcile.pdf|The reasons why are listed here]].
 
====Remittance check====
Contact tech support for assistance.

Latest revision as of 12:25, 21 November 2025

The Bank Reconciliation is an essential part of treasury work. Its purpose is to verify that your records in Jewel agree with what is actually happening in your bank account. Reconciling makes sure that you entered all transactions in Jewel and that you entered them correctly, as well as giving you a chance to catch any errors the bank may have made, or any fraudulent transactions.

Best practice is to reconcile monthly before closing the month. This allows you to catch mistakes or omissions when they are easiest to correct. However, if you cannot reconcile during your month-end closing for some reason, you may do so at any point during the monthly process of any future month by clicking Reconcile on the Jewel Home Screen. Keep in mind, though, that postponing or skipping reconciliation means that your Jewel records may not accurately reflect what has happened at the bank. Also, there is usually a strict time frame for reporting fraudulent transactions. So reconciliations should always be completed as soon as possible after receiving the bank statement.

The links below will answer your Bank Reconciliation-related questions.

Basic Info and Quick Start

Why Are Bank Recs Important?

Quick Start Guide to Bank Reconciliations

Quick Start - Adding Missing Transactions

Chapter 7: Making Corrections

Pictorial Tour of Jewel's Bank Reconciliation

Reconciling Specific Types of Accounts

Reconciling the Checking Account

Reconciling the Debit Account

Reconciling the Savings Acct

Setting Up and Reconciling a CD Account


Electronic Payments - Timing, Dates, Memos

Troubleshooting

Where Did My Reconciliation Go?



Return to Chapter 3: The Basic Jewel Processes

Continue to Chapter 5: Budget

Retrieved from "https://www.jewelsda.com/wiki/index.php?title=Bank_Reconciliation&oldid=1260"