Need Help?
  • Application Remote Support
  • Infrastructure Remote Support
  • Sage HRMS Remote Support
  • Helpdesk
  • General Inquiry
1-800-719-3307
Net at Work Net at Work
  • Solutions & Services
    • ERP/Accounting

      ERP Services
      Acumatica
      NetSuite
      Sage X3
      Sage Intacct
      Sage 100 ERP
      Sage 300 ERP
      Sage 500 ERP

      CRM

      Strategic Advisory Services
      Digital Marketing Solutions
      CRM Training Camp
      Salesforce
      Microsoft Dynamics 365 CRM
      Sage CRM
      Infor CRM (formerly Saleslogix)

      Employer Solutions

      Sage HRMS
      Sage People
      Criterion
      Miviva

      Enterprise Content Management

      Imaging / Scanning
      Document Management
      Workflow Automation
      Solutions

      Nonprofit Solutions

      Abila by Community Brands
      NetSuite
      Sage
      Salesforce

      IT and Security Services

      Managed IT Services
      Fractional CIO Services
      Cloud Services
      Cloud at Work
      DR/Business Continuity Planning
      Compliance & Security
      Storage & Recovery
      Networking
      IT Security Services
      Communications

      Web Solutions

      Services Overview
      B2B Technology Suite
      Magento eCommerce
      WordPress CMS
      Systems Integration
      Website Managed Services
      Online Marketing & SEO
      ERP eCommerce Integration

      Additional Solutions

      Enterprise Business Intelligence
      Avalara Automated Tax Solutions
      Fortis Payments
      LeaseQuery Lease Accounting
      Sage Fixed Assets
      Vertex SMB Sales and Use Tax
  • Industries
    • Industries

      Healthcare
      Chemicals
      Food & Beverage
      Medical Devices
  • Learning Center
    • Online Resources

      Recorded Webinars
      Whitepapers
      Ebooks

      Upcoming Events

      Live Webinars
      Seminars
      Virtual Training Courses

      Training Courses

      View all available training course options
  • Company
    • Why Us

      Who We Are
      Management
      Our Partners
      Locations
      Careers

      News

      Press Releases
      Success Stories
      Net at Work Blog

      Contact Us

      1.800.719.3307
      Email Us

      Programs

      Alliance Partnership Program
      Women at Work
      Diversity and Inclusion
  • Blog
  • Contact Us
  • Contact Us

Home » Newsletters » Sage 300 Newsletter – September 2016 » Sage 300 Bank Services – Best practices

Sage 300 Newsletter – September 2016

Keeping You Up-To-Date With Information About Sage 300

Sage 300 Bank Services – Best practices

By: Shirley Crocker, Senior Business Analyst

Do you maintain a separate spreadsheet to track your bank balance? Do you record entries that affect the cash account in the general ledger? If you answered yes to either of these questions, the article will show you how the bank reconciliation application in Sage 300 Bank Services can save you time and provide look up without referring to spreadsheets.

The first order of business is to setup a bank account in Sage 300 via Common Services, Bank Services, Banks. You will need to add the bank code and associate it to the appropriate General Ledger account for Bank Account, Write-Off Account and Credit Card Charges Account.

sage-300-bank-services-01

If you will be printing or writing checks from this account, the check stock code will also need to be added.
After the bank code has been added, the next step is to ensure that you have a current bank statement that has been reconciled to your general ledger bank account. We usually recommend selecting the end of the prior month.

Select Common Services, Bank Services, Bank Transactions, Reconcile Statements. Type in the bank code that will be reconciled.

In our example, the bank account code is WELLS. The manual reconciliation was done using a spreadsheet where there are $2,500.00 in outstanding deposits and $4,722.10 in outstanding withdrawals. We will need to update the bank reconciliation to reflect these outstanding transactions without updating the general ledger balances as the entries were done via journal entries.

The bank statement ending balance from the bank is $55,079.35. The end goal is to make the Adjusted Statement Balance match the Book and GL Balance. The print screen below reflects the initial statement balance and GL balance.

sage-300-bank-services-02

In order to update the outstanding deposits and outstanding withdrawals separate entries can be made. An extra entry will be made to update the book balance. The steps are as follows:

  1. Select Common Services, Bank Services, Bank Transactions, Bank Entry
  2. Tab to the description field and type a meaningful description
  3. Type the bank code and/or use the Finder to locate the bank code
  4. Ensure that the Bank Entry Type is Deposits
  5. Select the appropriate deposit type from the drop-down
  6. Type the date of the deposit
  7. In the detail area, enter the GL account associated to the bank code
  8. Type the amount of the deposit
  9. Type a meaningful description in both the Reference and Description fields
  10. Add
  11. Repeat steps 1-10 for each outstanding deposit

sage-300-bank-services-03

To enter the outstanding withdrawals, the steps are similar:

  1. Select Common Services, Bank Services, Bank Transactions, Bank Entry
  2. Tab to the description field and type a meaningful description
  3. Type the bank code and/or use the Finder to locate the bank code
  4. Ensure that the Bank Entry Type is Withdrawals
  5. Select the appropriate Withdrawal type from the drop-down
  6. Type the date of the Withdrawal
  7. In the detail area, enter the GL account associated to the bank code
  8. Type the amount of the withdrawal
  9. Type a meaningful description in both the Reference and Description fields (type the check number if this is an outstanding check)
  10. Add
  11. Repeat steps 1-10 for each outstanding withdrawal

sage-300-bank-services-04

One last entry must be done in order for the Book Balance to match the GL Cash balance. In our example, the GL Balance is $52,857.25. We have entered outstanding deposits totaling $2,500.00 and outstanding withdrawals totaling $4,722.10. The difference is $55,079.35. To update the book balance, we will repeat the steps used to enter a deposit. An example is below:

sage-300-bank-services-05

After this entry has been added, all of the entries must be posted to update the book balance. This is done by:

Selecting Common Services, Bank Services, Bank Transactions, Post Entries

sage-300-bank-services-06

Let’s go look at the bank reconciliation screen after the entries have been posted:

sage-300-bank-services-07

In order to clean up/zero out the “Out of Balance by” we will need to clear the bank entry made to update the opening Book Balance:

Click on the Reconciliation tab. Double-click in the field labeled Reconciled on the row where the Bank entry had been made. An “X” will appear and the Out of Balance by at the bottom of the screen will be 0.00.

sage-300-bank-services-08

Select the Summary tab to review the Statement Balance, Deposits Outstanding, Withdrawals Outstanding, Adjusted Statement Balance and Adjusted Book Balance.

sage-300-bank-services-09

Select Save to save this reconciliation. Close the screen.
The last step is to post the Reconciliation. Go to Common Services, Bank Services, Bank Transactions, Post Reconciliation.

sage-300-bank-services-10

The post process will update the bank balance and create a batch for the general ledger. Because the cash account was used for the entries, you can either delete the batch in General Ledger or Post it as the end result will not affect the cash account balance.

In order for the book balance to stay in synch with the General Ledger balance, do NOT post any journal entries to the cash account. All entries that will affect the bank should come into bank services via Accounts Payable, Accounts Receivable, Payroll or a bank entry.

In summary, getting the bank reconciliation to match the general ledger balance can ultimately save a lot of time after tying it out the first time. Give us a call or send us an e-mail if you would like to ditch the spreadsheet(s)!

« Return to Newsletter

In This Issue
  • From the Desk of the Sage 300 Practice Director
  • Announcing Sage 300 and 300C (Sage 300cloud) version 2017
  • Sage 300 Bank Services – Best practices
  • Fair Labor Standards Act Exemptions from Overtime Redefined
  • An Introduction to Sage 300 .NET API
  • Sage Year-End Promotions
  • Sage 300 Support

    Helpdesk:
    P: 888.494.9479
    E: helpdesk@netatwork.com

    Sage 300 Webinar Series

    Tips for Sage Users to Improve Data-Driven Decision-Making
    March 28 | 2pm ET
    Register Here

    Recruiting & Quiet Hiring: What Quiet Quitting / Hiring Means for 2023 & How Technology Can Help
    March 28 | 2pm ET
    Register Here

    Sage-Integrated Document Management: From Chaos to Control
    April 7 | 2pm ET
    Register Here

    Sage Intacct Overview Demo
    April 7 | 2pm ET
    Register Here

    Popular Recorded Webinars

    Sage Cloud Hosting: Moving On-Premise Sage 300 to the Cloud

    Building a Next Generation Finance Organization with Next Gen ERP Tools

    Reducing Manual Tasks in Your Sage Accounting & Shipping Processes

    Bridge Your Sage 300 Gaps

    Sage 300 Webinar Archive

    View our library of on-demand recorded webinars.

    Newsletter Archive

    Read our previous Sage 300 Newsletters here

    Connect With Us

    Business Applications

    • Overview
    • ERP/Accounting
    • Cloud ERP
    • CRM
    • Employer Solutions
    • ECM
    • Nonprofit Solutions

    Learning Center

    • White Papers & Guides
    • Ebooks
    • Training Courses
    • Virtual Training Courses
    • Success Stories
    • Live Webinars
    • Recorded Webinars
    • Trials

    Infrastructure Solutions

    • Overview
    • Solutions
    • Managed IT Services
    • Fractional CIO & Advisory Services
    • Cloud Services
    • Cloud at Work
    • Compliance & Security
    • DR/Business Continuity

    Support

    • Application Remote Support
    • Infrastructure Remote Support
    • Sage HRMS Remote Support
    • General Inquiry
    • Helpdesk

    Web Development

    • Services Overview
    • Magento eCommerce
    • WordPress CMS
    • Systems Integration
    • Website Managed Services
    • ERP eCommerce Integration

    Company Information

    • Why Us
    • Alliance Partnership Program
    • Women at Work
    • Diversity and Inclusion
    • Partners
    • Careers
    • News
    • Blog
    • Privacy Policy
    • Contact Us

    Additional Solutions

    • Enterprise Business Intelligence
    • Avalara Automated Tax Solutions
    • Fortis Payments
    • LeaseQuery Lease Accounting
    • Sage Fixed Assets (Sage FAS)
    • Vertex SMB Sales and Use Tax

    Industries

    • Healthcare
    • Chemicals
    • Food & Beverage
    • Medical Devices
    Net at Work
    Net at Work (HQ)
    575 8th Ave
    New York, NY 10018

    P: (800) 719-3307
    info@netatwork.com
    Locations Across North America »
    Visit our sister companies:
    Cloud at Work - Sage Application Hosting
    Pixafy - An eCommerce Agency
    Docutrend
    WordPress Image Lightbox Plugin