Bank Reconciliation Reports Do Not Have the Requisite Information Needed for a Proper Bank Rec Report

Bank Reconciliation Reports Do Not Have the Requisite Information Needed for a Proper Bank Rec Report

Basic accounting practices for bank reconciliations dictate that bank reconciliation reports have the following components:

  1. Date or Period of Reconciliation:
    1. The report should clearly state the date for which the reconciliation is being performed, typically at the end of a month.
  2. Bank Statement Balance:
    1. The ending balance as per the bank statement on the reconciliation date.
  3. Book Balance (General Ledger Balance):
    1. The ending balance as per your company’s books (general ledger) on the reconciliation date.
  4. Adjustments to Bank Balance:
    1. Outstanding Checks: Checks that have been issued by the company but have not yet cleared the bank.
    2. Deposits in Transit: Deposits recorded in the company’s books but not yet reflected on the bank statement.
    3. Bank Errors: Any errors made by the bank that need to be corrected.
  5. Adjustments to Book Balance:
    1. Bank Fees: Fees charged by the bank that were not recorded in the company’s books (e.g., service fees, check printing charges).
    2. Interest Earned: Interest earned on the bank account that hasn’t been recorded in the books.
    3. NSF (Non-Sufficient Funds) Checks: Checks that were deposited but bounced due to insufficient funds.
    4. Automatic Payments/Withdrawals: Any automatic payments or withdrawals recorded by the bank but not yet in the company’s books.
    5. Book Errors: Any errors in the company’s books that need to be corrected.
  6. Adjusted Bank Balance:
    1. The bank statement balance after adjusting for outstanding checks, deposits in transit, and any bank errors.
  7. Adjusted Book Balance:
    1. The book balance after accounting for any bank fees, interest, NSF checks, automatic payments, and book errors.
  8. Reconciliation:
    1. The report should show that the adjusted bank balance equals the adjusted book balance. If there’s a difference, it should be explained and resolved.
  9. Supporting Documentation:
    1. Attach copies of the bank statement, deposit slips, and checks to support the adjustments made during reconciliation.
  10. Optional:
    1. Some reports will also show the list of all cleared/matched deposits (monies in) and all cleared/matched expenses (monies out).

At this point, of the 9 essentials and 1 optional item, ZOHO Books bank and credit card reconciliations only has numbers:
1. Date or Period of Reconciliation,
9. Supporting Documentation, and
10. List of cleared/matched deposits and expenses.

It feels like Books has developed and tested by bookkeepers rather than qualified accountants. SMH.

      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ






                                ご検討中の方

                                  • Recent Topics

                                  • Sheet View in CRM portal

                                    Hi, When will it be possible for my CRM portal users to edit/add records with Sheet View? George
                                  • What's New in Zoho Invoice | July - September 2025

                                    Hello everyone! We’re back with the latest updates and enhancements we’ve rolled out in Zoho Invoice from July to September 2025. Here’s what’s new this quarter: Introducing the Singapore Edition in Zoho Invoice Share Invoices through WhatsApp GST 2.0
                                  • Alert: Audio Call Support to be discontinued for Old Live Chat Widget from December 31, 2025

                                    Action Required: Upgrade to the New SalesIQ Live Chat Widget We're reaching out with an important update regarding the SalesIQ Live Chat Widget that requires your immediate attention. Effective December 31, 2025, audio call functionality will no longer
                                  • multiple contacts for one account

                                    We currently use Zoho CRM where each Account represents a club or organization, and each Contact represents a manager or owner. However, some of our managers own or manage multiple clubs, and Zoho only allows a contact to be linked to one account at a
                                  • Rich text Merge field - Not using font specified in HTML

                                    I have a rich text merge field in a writer template which is creating a table. I have chosen to use this method instead of a repeat region because I need to specify specific cell background colours which change every time the document is created. The
                                  • ヒートマップ詳細設定について

                                    はじめまして マーケティング担当の浅田です。 PageSenceのヒートマップ設定について質問です。 単一ページ毎の設定は上手くできるのですが 詳細設定にて、トップページのURLを含ませ全体のヒートマップを計測できないか試したところ お知らせ:データを受信していません。と表示されてしまいます。 トップページURLで始まるページの条件も試しております。 全頁を反映させたいと思い、詳細設定を上手く設定できたらと考えております。 どなたか詳しい方がいらっしゃいましたら、教えて頂けませんでしょうか 宜
                                  • Automatic category assignment

                                    Hi, I’d like to ask if there is a way to automatically assign an expense category based on the recognized Merchant. What would be the simplest way to set up automatic category assignment? Alternatively, is there an option to first choose the category
                                  • Experience with Zoho Vertical Studio

                                    I'm considering Zoho Vertical and would love to hear from some devs who've been using it. The Zoho ecosystem is pretty solid, so I assume the experience has been pretty good, but sometimes Zoho has its quirks. Overall, has your experience been positive?
                                  • LinkedIn Chrome Extension

                                    Hello - I believe it is a known issue that the LinkedIn extension Resume Extractor has stopped working and they are working on potential fixes. Wondering how others users are finding this issue and if there are any better workarounds for this issue? It
                                  • Advance PDF creation from CRM data

                                    I'm trying to create a PDF export of data in the CRM. My problem is I want a pretty complicated format for the data. I'm trying to export multiple modules worth of data, with nested one-to-many relationships between the modules. Along with that, I want
                                  • Sub-Form Padding in CSV Export

                                    Hi, When you use the Sub-Form, and for example you have a Date Field on the Main Page, then Option 1 and Option 2 fields on the Subform, when you export this to CSV the Date column will only have the Date in 1 row, the first row, it would be nice to pad
                                  • More Formula Functions

                                    Hi, I would like for example to be able to have a Date Field and Formula Fields, and then in the Formula Fields I would like to grab just the Month of the above Date Field or the Week Number of the above Date Field. So more "Functions" than the current
                                  • File upload size limits

                                    I am designing a contact form in Zoho Creator with File upload facility. I am not sure where and how to set the following properties for the same: Allowed File Types Maximum Size of the Attachment Number of Attachments
                                  • Composite Services and Account Tracking

                                    I am looking to garner support/request the ability to make composite services. A quick search in the forums brings up multiple requests for this feature. I fail to see why an item is mandatory while services are optional. I also would like to see the
                                  • All operation codes getting Not applied in WO-TT22J1025WOR0471, SR-TT22J1025PRE0423,FOR VIN-W1K6G2AB2SL005130.

                                    Dear Support Team, Please refer attached screenshot. All operation codes getting not applied in work order. Request you to please check and update ASAP.
                                  • Exclude Segment from Campaign Recipients

                                    I've created two Segments in order to separate Non-Marketing Contacts from Marketing Contacts. I'd like to send an Eblast to all Marketing contacts in my lists, but when I go to select Recipients, I have two options: 1. To Choose Lists to Send to; 2.
                                  • Reschedule Multiple/Mass Calls at Once

                                    When we go into a Call record, we have the option to "Reschedule Call." How can we select multiple Calls at once from the Activities tab and Reschedule them? The big use case for us: We have many leads that our reps are supposed to call on a daily basis.
                                  • Option to Empty Entire Mailbox or Folder in Zoho Mail

                                    Hello Zoho Mail Team, How are you? We would like to request an enhancement to Zoho Mail that would allow administrators and users to quickly clear out entire folders or mailboxes, including shared mailboxes. Current Limitation: At present, Zoho Mail only
                                  • I want to Make the due date of the project appears automatically

                                    hello everyone I want to know if the zoho projects app can add automatically the END DATE of the project I added the duration, start after dates of each tasks in the project template & the starting date of the project itself and the end date of it doesn't
                                  • Drag 'n' Drop Fields to a Sub-Form and "Move Field To" Option

                                    Hi, I would like to be able to move fields from the Main Page to a Sub-Form or from a Sub-Form to either the Main Page or another Sub-Form. Today if you change the design you have to delete and recreate every field, not just move them. Would be nice to
                                  • Deluge Tips & Tricks: Mastering dates and times

                                    Hello everyone! We're bringing back our Deluge Tips & Tricks series, where we show you how to make the most of Deluge for achieving a wide range of use cases. Working with dates and times is a fundamental part of almost any business application. Whether
                                  • Adding a Button in a Form in Zoho Creator App

                                    Hi I want to know how can I add a Button in Zoho Creator form. I have options that I select from a multiselect options and I want the button to add those selected options in a Subform. I do not want to add on a Page Builder I want it inside a specific
                                  • Internal Exception for Creator function

                                    I have been running a script successfully for several days using the scheduler in my application. Now today it suddenly creates and Internal Exception error. Nothing has changed about the script. The data is still retrievable from the web service it is using. Why would this suddenly be happening for no apparent reason? Also noticed that my usage logs are not up to date. Is something changing behind the scenes?
                                  • How to Set Up a Custom Domain and Customize Homepage

                                    Hello, I am experimenting with Zoho Creator to build applications for my own use case and have encountered a couple of issues: 1. Custom Domain Access: Is it possible to access my Zoho Creator application through a domain that I own? If so, how does the
                                  • Announcing new features in Trident for Mac (1.26.0)

                                    Hello everyone! Trident for macOS (v1.26.0) is here with new updates to securely manage your passwords, locally save your emails, and protect against emails with suspicious URLs. Let's take a quick look at them. Manage passwords with Zoho Vault eWidget.
                                  • Default Value on a Number

                                    Hi, I would be nice to also be able to set the Default Value for a Number Field, not just the Initial Value shown, so if not on the screen so not enetred it can have a value of 0 for example. Thanks Dan
                                  • Having trouble fetching contents of Zoho Connect Feeds using the API, requesting alternative API documentation.

                                    I'm trying to retrieve feed/post data from Zoho Connect using the API but facing challenges with the current documentation. What I've tried: OAuth authentication is working correctly (getting 200 OK responses) Tested multiple endpoints: /pulse/nativeapi/v2/feeds,
                                  • Tip#45: Custom Tags and Cluster Tags

                                    Tagging your work items helps categorize and label work items within your Zoho Sprints workspace. Now, this feature is expanded across multiple modules, along with the introduction of cluster tags that offer an advanced tagging mechanism. Manage Tags
                                  • Extensions 101 webinar series: Build, integrate, and monetize with extensions

                                    Attention developers! Are you ready to take your extension development skills to the next level? We're excited to bring back the Extensions 101 webinar series with an expanded lineup of Zoho products and an introduction to more platform features. Last
                                  • [Free Webinar] User Management in Zoho Creator - Creator Tech Connect

                                    Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
                                  • A couple of minor enhancements to Workflows

                                    Last updated on September 17, 2024: These enhancements were initially available for early access, and we've now enabled them for all users. We are elated to announce a couple of enhancements to custom functions in our Workflows! Say hello to: "Source"
                                  • Business Continuity - Disaster Recovery

                                    I know about the Zoho CRM backup .zip files, however, this doesn't include any of the infrastructure with like custom fields or custom modules. I am curious on what everyone has in place for a true backup or what your plan is if your Zoho instance were
                                  • Narrative 11: Are your customers happy?

                                    Behind the scenes of a successful ticketing system: BTS Series Narrative 11: Are your customers happy? Happiness isn't just something you experience; it's something you remember. Hear your customers' voices by enabling customer happiness ratings in Zoho
                                  • Don't understand INVALID_REQUEST_METHOD when I try to post up an attachment

                                    When I make the POST request (using python requests.post() for files): https://www.zohoapis.com/crm/v8/Calls/***************01/Attachments I get this response: r:{ "code": "INVALID_REQUEST_METHOD", "details": {}, "message": "The http request method type
                                  • Signature field is showing black

                                    Hello, When customer signed the service form, it is showing as below picture Phone model: iPhone 16 Pro We tried delete and install application, but it not solved. This has on phone of a few person. There is any advice to solve this?
                                  • Zoho CRM Android app updates: record sharing, user image upload, Zoho Survey integration, and more

                                    Hello everyone, We've made some important improvements to Zoho CRM's Android app, and we'd like to walk you through the latest updates. Here's what's new: Record sharing with org users User image upload Zoho Survey integration support Venue preference
                                  • How to Delete/hide Google adwords section from Layout?

                                    Hi people, maybe someone can tell me how to remove or hide the Google adwords section from my layout? Im not using it and it takes too much space.
                                  • WIDGET in related record list ZOHO CRM; how to get and put data to subform custom fields?

                                    he need: Read and write two custom subform line-item fields on Quotes: Segment_wyceny (picklist/text) and W_pakiecie (number). Write works; read does not return these fields via SDK. Environment Zoho CRM Widget Zoho Embedded App SDK v1.2 Module: Quotes
                                  • Introducing Assemblies and Kits in Zoho Inventory

                                    Hello customers, We’re excited to share a major revamp to Zoho Inventory that brings both clarity and flexibility to your inventory management experience! Presenting Assemblies and Kits We’re thrilled to introduce Assemblies and Kits, which replaces the
                                  • Way to update CRM records in quik view

                                    I have custom module in zoho crm and that module have 500 records. I want a quick way or UI so that user can easily update the record information in quick view without going to record detail view or edit view. I tried zoho sheet option but in zoho sheet
                                  • Next Page