- EBMS Knowledge Base
- Financials
- Account Reconciliation
-
Client Resources
-
EBMS Main Documentation
- Introduction
- Getting Started
- Getting Started | Initial Installation
- Getting Started | Company Setup
- Quick User Guide | Financial Staff | Accountant
- Quick User Guide | Financial Staff | Accountant | Accountants Journal
- Quick User Guide | Sales Staff
- Quick User Guide | General Staff
- Features
- Reports
- Reports | Excel Add-In
- Reports | Excel Add-In | Troubleshooting
- Security
- Server Manager
- Technical
- Technical | Data Import and Export Utility
- Technical | SQL Mirror
- Automotive
- Automotive | Parts Catalog
- Automotive | Pricing
- Automotive | Point of Sale
- Automotive | Product Application
- Automotive | Keystone Interface
- Metal Supply
- Fuel Sales
- Horticulture
- Horticulture | Farm Setup
- Horticulture | Processing Payroll
- Horticulture | Managing the Farm
-
Sales
- Introduction
- Customers
- Customers | Miscellaneous Customers
- Proposals
- Proposals | Processing Proposals
- Proposals | Sets and Templates
- MyProposals
- MyOrders
- Sales Orders
- Invoices
- Materials Lists
- Sales and Use Tax
- Sales and Use Tax | TaxJar
- CRM
- CRM | Auto Send
- Recurring Billing
- Credits
- Customer Payments
- Payment Card Processing
- Payment Card Processing | Gift Cards
- Payment Card Processing | Loyalty Cards
- Payment Card Processing | Verifone Gateway
- Freight and Shipping Tools
- General Ledger Transactions
- Point of Sale
- Point of Sale | Point of Sale Hardware
- Point of Sale | Xpress POS System
- Point of Sale | Advanced Tools
- Signature Capture
- Salesperson Commissions
-
Inventory
- Product Catalog
- Product Catalog | Using Product Codes for No Count Items
- Product Pricing
- Product Pricing | Special Pricing
- Tracking Counts
- Unit of Measure
- Purchasing
- Special Orders and Drop Shipped Items
- Receiving Product
- Barcodes
- MyInventory and Scanner
- Components (BOM) and Accessories
- Components (BOM) and Accessories | Component Formula Tool
- Made-to-Order Kitting
- Configure-to-Order Kitting
- Multiple Inventory Locations
- Multiple Inventory Locations | Creating Locations
- Multiple Inventory Locations | Using Multiple Locations
- Multiple Inventory Locations | Product Catalog Sync
- Multi-Vendor Catalog
- Serialized Items
- Serialized Items | Purchasing or Manufacturing an Item
- Serialized Items | Selling and/or Associating an item with a customer
- Lots
- Product Attributes
- Product Attributes | Selling and Purchasing Items with Attributes
- Product Attributes | Custom Attributes
- Mobile Scanner (Legacy)
-
Labor
- Getting Started
- Workers
- Taxes and Deductions
- Work Codes
- Time and Attendance
- Time and Attendance | Time Track App
- Processing Payroll
- Closing the Payroll Year
- Processing Payroll - Advanced
- Salaried Pay
- Piecework Pay
- Direct Deposit
- 3rd Party Payroll Service
- Subcontract Workers
- Flag Pay
- Prevailing Wages
- MyDispatch
- MyTasks
- MyTime
- MyTime | Communications
- MyTime | Setup
- Tasks
- Tasks | Getting Started
- Tasks | Creating Tasks
- Tasks | Scheduling Tasks
- Tasks | Customizing Task Views
- Tasks | Managing Tasks
-
Financials
- Introduction
- Fiscal Year
- Chart of Accounts
- Budget
- Financial Reporting
- Transactions and Journals
- Transactions and Journals | Journals
- Account Reconciliation
- 1099
- Departments and Profit Centers
- Fund Accounts
- Bank Accounts
- Bank Feed
- Vendors
- Vendors | Miscellaneous Vendors
- Purchase Orders
- Expense Invoices
- Vendor Payments
- AP Transactions
- Landed Cost
- Fixed Assets and Depreciation
- Fixed Assets and Depreciation | Fixed Assets
- Fixed Assets and Depreciation | Fixed Assets | Adding Assets
- Fixed Assets and Depreciation | Processing Depreciation
- Fixed Assets and Depreciation | Disposing Assets
- MyJobs
-
E-commerce
-
Rental
-
Job Costing
-
Manufacturing
Correcting Differences in Reconciliation
If there is a difference when reconciling the bank account and it can be traced to a specific deposit or check payment, go back and edit the deposit or check payment. By making the correction to the source document, all totals and posting will be updated properly. If the correction to the source document is not made, there is a possibility that corresponding vendor or customer totals will be wrong. Make sure transactions of the corrected document have been posted to update the reconciliation list.
If you cannot locate the cause of a difference between the account balance and the bank statement, an adjustment is necessary. Please note that this will not correct the incorrect transaction but will only adjust your account balance so that it agrees with the bank statement.
Making Adjustments
EBMS includes two convenient ways to adjust an account:
The recommended method although it requires more financial understanding of the general ledger system in EBMS to create an adjusting journal. Review the Journals > Creating Journal Entries section for details on this option.
The similar method although it does not contain a detailed supporting document is described below:
Open the tab where the adjustment is to be inserted (Cash In or Cash Out). Click the Adjustments button to insert new transactions directly into the tab. This function is useful to enter bank account adjustments, fees, or miscellaneous debits when reconciling a bank account. Reconciling a cash account may require a miscellaneous adjustment to the general ledger balance so it matches your current cash balance. This feature should only be used for adjustments and should not be used to replace the invoice or deposit processes.
The adjustment window allows three types of adjustments:Expense adjustments are credits to the account and will display in the third tab.
Income adjustments are debits to the account and will be displayed in the second tab.
Transfers are used to transfer monies from one account to the other. The system will credit the current account and debit the selected Transferred To: bank account. The Transferred From account is always the account being reconciled and cannot be changed. To transfer into this account go into the account you are transferring from.
Enter the transaction Date. This date will default to today's date.
Enter a brief Description of the adjustment.
Set the G/L Account that you wish to use to offset this transaction. This would normally be an expense general ledger account for an expense transaction, a revenue account for an income transaction, or a bank account for a transfer transaction.
Enter the dollar Amount of the transaction and click OK.