Execu/Tech Systems, Inc.
Knowledgebase
Search:
850-747-0581
Email
Website
Contents
Index
Search Results
Welcome
What's New
Glossary
System Requirements
Computer Hardware
Other Hardware
Operating Systems
Windows XP Support Ends
Server 2003 Support Ends
TLS 1.2 Requirements
Data Security
Firewall Settings
Credit Card Interfaces
Installation Checklists
Flowchart
Software Update Requirements
Questions and Answers
Common Questions
Common Mistakes
Sending a Screen Shot
Sample Reports
Execu/Tech Services
Execu/Suite Hotel PMS
Execu/Suite Hotel PMS Setup
Installation
Data Preparation
Software Installation
Software Installation - Server
Software Installation - Client
Software Reinstall / Move
Your Company Setup
Create Shortcut Manually
Running as RemoteApp
Zip Code Database
License Access Code
Setup Bullet Points & Notes
Rooms, Room Types, Rates
Charge, Payment, Tax Codes
Guest Packages
User IDs & Security Levels
Parameters & Policies
Guest Profile Tabs and Fields
Market and Source Codes
Manager Menu / Setup
Getting Started
Hotel Control Files Setup
Parameter Record
Season Record
Rooms
Room Types
Tax Codes
Charge Codes
Payment Codes
Guest Packages
Market Segment Codes
Source of Business Codes
Corporate File
Guest Profile Tools
Housekeeping Codes
Yield Management
Meeting Room Parameters
User Defined Comments
Graphical Room View
Auto-Trace Setup
Wholesalers and Travel Agencies
User I.D. / Security Setup
PMS Employee Setup
PMS Menu Permissions
Security Levels
Other Settings
Configuration Settings
CRM Sync
Edit HTML Templates
Editing HTML Letters, Documents and Forms
Email Settings
Enable PDF Saving
Hotel Logo
Import Rate Spreadsheets
Master Folios
MENUINI.FIL Configuration
Terminal ID Number Codes-Batch Terminals
Data Flow
Execu/Suite Hotel PMS Procedures
Guest Name Changes-Profile
Front Desk Operations
Front Desk Menu
Availability
Guest Profile
Check In
Credit Card Procedures
Check-In CC Preauth Video
Check In Master Folio
Packages
Guest Folio
Changes - Room, etc.
Posting Charges & Payments
Check Out
Check Out w/ Credit Card-Video
Housekeeping
Front Desk Reports & Printouts
Reservations Operations
Reservations Menu
Availability
New Reservations
Guest Profile
Advance Deposits
Credit Card Video-Res
CC Adv. Dep Refund Video
Share-withs
Changing Reservations
Cancellations and No-Shows
Guest Opt-out
Reservation Reports & Printouts
Sample Reports
Trace Reports
Groups
Night Audit
Night Audit FAQ
Night Audit Procedures
Night Audit Bullet Points
Night Audit Reports
Folio Detail Export
Clearing Adv. Deposits Remaining
Guest History
Manager Reports
Manager Procedures
Adjusting Statistics-AM Report
Audit Archive Report Viewer
Other Manager Tasks
Travel Agency Processing
Travel Agency Setup
Travel Agency Reports
Travel Agency Checks
Report Generator
How-To Videos and Tutorials
Assign Master Folio to Guest or Group
Change Terminal Number
Check In a Guest
Check Out a Guest
ETShortcutWizard
Export Guest Contact Info
Guest Profile Creation
Housekeeping Screen - Changing Status
Interface - Create a Scheduled Task
Software Update
Posting Charge or Payment to Folio
Transfer Charge or Payment to a Folio
Voiding Charge or Payment in Folio
How-To Documents
Post CC After Check-out
Credit Card Reminders
Change Company Code
Interfaces
OTA / HTNG
OTA / HTNG 2 Way Push
OTA / HTNG Installation and Configuration
OTA 1 Way Pull
OTA / HTNG Functions and Limitations
OTA / HTNG PMS Settings
OTA / HTNG Troubleshooting
OTA / HTNG Logs
Phone, Movie, POS, etc.
Comtrol® Interfaces
Comtrol® Network Requirements
Comtrol® Install
Comtrol® Setup
Comtrol® Testing
Comtrol® Resync
Comtrol® Troubleshooting
Legacy Interfaces
Legacy Interface Installation
Communication Settings
Phone Interface Resync
Troubleshooting Serial Connections
Micros POS Interface
WebRes
WebRes - Installation
WebRes - Credit Card Processing
WebRes - Shift4
WebRes - Vantiv
WebRes - Customize / Configure
WebRes - Cancellation Policy
WebRes - Confirmation Page and Email
WebRes - Errors / Troubleshooting
Marina and RV Settings
Execu/Touch Point Of Sale
Execu/Touch POS Administrator
POS to Hotel Data Flow
Store Record
Departments/ Revenue Centers
Payment Records
Discount Records
Menu Items
Item Modifiers
Item Categories
Combinations (Value Meals)
Employee Records
Employee Work Codes
Void Codes
Table Setup
Terminal Records
Printer Setup
Item Button (Keyboard) Setup
How To - POS Admin
Create POS Item
Execu/Touch POS Procedures
F&B Open a Check
F&B Close a Check
Separate Checks
Split Checks
Split Tendering
Retail Procedures
Reports
Supervisor
Paid-Out Tips and Other
Create TAB
Transfer Checks
Video-Credit Cards in POS
Print Bar Codes
Advance Deposit in POS
Execu/Touch POS Miscellaneous
POS Cash Management
Dining Reservations
Tableside Wireless Tablets
Edit/ Purge History Records
Add Comment to POS Guest Receipt
Configure Bar Code Printer and Labels
Suppress Remote Printing
Use Employee Login Cards
Encode Employee Login Cards
Activities Deposits POS Setup
Export POS Check Detail (GAPOCKH.TXT)
POS Copy / Delete Records (GAPOCOPY)
POS Copy all records to another store
POS Copy records from GAPOCNTL.OLD
POS Delete Records
POS Change item fixed tax amount
POS Reset Table Types
POS Resynch employee/password records
POS Copy ONE record to another store
POS Convert gapo999.fin's
Printers and Cash Drawers
POS Printer Setup
POS Printer Troubleshooting
Cash Drawer Setup
Payment Processing
EMV Credit Card Processing
Vantiv / Worldpay Credit Card Processing
Vantiv EMV PIN Pad Setup
Vantiv EMV Cloud Config
Vantiv EMV Failure Messages
Vantiv EMV PIN Pad Troubleshooting
Vantiv EMV Data Flow
Vantiv (Non-EMV) Data Flow
Vantiv Receipt Printer Setup
Shift4 Credit Card Processing
Shift4 Card Readers
Magtek Programming
Shift4 EMV
Shift4 Data Flow
Shift4 Installation
Shift4 i4Go V2
Shift4 i4Go V2 Requirements
Shift4 i4Go V2 Errors
Shift4 i4Go V2 PMS / POS Settings
Shift4 i4Go V2 Internet Explorer Trusted Zone
Shift4 SSL Certificates
Shift4 Receipt Printer Setup
Credit Card Procedures
Switching Gateways/Providers
Inventory Control
Inventory Overview
Inventory Setup
Store, Locations, Classes-Categories
Inventory Items
Recipe File
Inventory Processing
Physical Inventory Entry
Physical Inventory Handheld Scanner
Purchase Orders
Miscellaneous Postings
Enter Waste Adjustments
Batch Updating
Display Item Detail
Inventory Integration
Integration to POS
Integration to A/P
Integration to GL
Inventory Reports
Time & Attendance
Direct Bill / City Ledger
Setup
Control Files Setup
Customer Setup
Membership Billing
Direct Bill - Execu/Suite PMS Interface
Direct Bill - Execu/Touch POS Interface
Direct Bill - General Ledger Interface
Procedures
Hotel DB Transfers
Transaction Batches
Open Item Payments
Manual Postings
Fix Out of Balance Direct Bill Accounts
Late Fees
Member Billing
Reports and Statements
Sample Reports
Customer Aged Trial Balance
Customer Detail Report
Transaction Batch Update Report
Open Item Statements
Balance Forward Statements
A/R Report Generator
Events and Catering
Getting Started
Event Setup
Sample Reports
Gift Cards (Execu/Gift)
Execu/Gift Setup and Configuration
Selling/Issuing Gift Cards
Redeeming Gift Cards
Manual Entry / Edit / Delete
Donated Gift Cards
Reward cards
Gift Card Reports
Encode Gift Cards
Back Office
General Ledger
GL Setup
GL Processing
GL Integration
GL Reports
Accounts Payable
A/P Setup
A/P Processing
A/P Reports
Condo
Condo Overview
Condo Setup
Condo Procedures
Condo Reports
Payroll
Payroll Setup
PR - GL Interface Setup
Company
Federal Tax Tables
Employee Setup
PR-TimeClock Interface Setup
Payroll Procedures
Payroll Reports
3rd Party Accounting Interfaces
GL Export
DataPlus
QuickBooks
Errors / Fixes
cbl.out Program Missing
Class Not Registered
Cobol Errors
Common System Issues
Company Selection Keeps Appearing
Detail File Update Error
Find Software Application Folder
Folio Stops Printing (HTMLPRNT.EXE)
Forms Print Too Large
Microsoft .NET Framework
Microsoft.Office.Interop
Missing or Broken Shortcut / Icon
Network Benchmark
Rebuild Corrupted File
Rebuild Cross Reference
Register Programs and Controls
Restarting Servers and Terminals
Run Program By Name
Run-time error '429'
Run-time error '-2147319779'
Program Warnings
Cannot Run More Than Once
Could Not Read Card
Current time not set up
In Reorg - Not Posted
Invalid Company Code
Invalid Room Type
Keyboard Record Not Set Up
Record Busy Message
Software License Warning
Terminal Record Not Set Up
Shift4 Troubleshooting
Shift4 UTG IP Address and Port
Shift4 Error Codes
Test Shift4 UTG Connection with Telnet
Shift4 Errors
Slow / Stuck Software
Start Program Missing
Support File Uploader
Unable to Select Printers
User Account Control (UAC)
Execu/Vault
Remote Connection (RemoteET)
Uninstall Old Remote Connection App
Year-End Procedures
Fiscal Year
Master Folios Year-End
Seasons and Rates
Advance Deposits
Server and System Health
PCI Compliance
City Ledger - Direct Bill
General Ledger
Accounts Payable
Payroll
Backup and Storage
Training
New Modules
Execu/Suite Activities
Execu/Spa
Cloud Hosting
Cloud Hosting Access
Cloud Launcher Install
Cloud Launcher Setup
Cloud Launcher Update
Cloud Access for Mac
Cloud Hosting Preparation
Network / Hardware Requirements
Important Issues
Document Access
Index
Bookmark
Print This Article
Login
Home
>
Direct Bill / City Ledger
>
Procedures
>
Fix Out of Balance Direct Bill Accounts
When making payments on Open Item Direct Bill accounts, if your software locks up or is terminated without completing the transaction, the account might become out of balance. If the account is out of balance, it's because the total of the payment transactions doesn't match the total 'Amount Paid' field in the invoice (charge) record.
You'll know that the account is out of balance by looking at the Open Item Payment Entry screen and comparing it to the Display Account Detail screen (Make sure you answer "No" when asked if you want to show unpaid invoices only).
This is a simplified example, but the same process is used no matter how large the mess.
Here you can see that the Open Item Payment Entry screen shows a zero dollar balance and no unpaid invoices.
But, if you look at the Display Customer Detail screen , you see that it shows a balance due.
Looking at the detail, we can see that there is a $150 payment missing and that the likely invoice involved is the second one from the top, for $150.00. It shows paid, but we see no matching payment. This tells us that something went wrong when its payment was applied. In this case, because it's easy to identify the problem, we're going to use the first method to fix the account.
Often, though, it isn't this simple and you can't determine when the problem occurred or which invoices are invoiced, especially in an account with a lot of activity. This is when we use the second method.
You can also print the Customer Aged Trial Balance report, and it will show two asterisks (**) to the right of the account balance line. This is an indication of an out of balance account that need to be fixed.
These are the two methods used to fix an out of balance account.
Reset the Amount Paid
Create an Adjustment and Force it Paid
Reset the Amount Paid
Using this method, the Amount Paid is reset to what it was before the faulty payment was made. Once this is done, the payment is reapplied as if it never happened in the first place.
Invoices must be selected and reset ONE AT A TIME.
From Customer Processing, go to Enter Open Item Payments, and enter the customer code.
Payment Date is today.
Payment Code is "P".
Reference is blank.
Payment Amount is 0.
If the invoice you're looking for shows paid in full, type "A" and press Enter i
n the "Invoice/seq to pay" field,
to see all invoices.
Enter the Sequence Number (the number in the first column of the invoice table) of the first invoice to adjust.
Press Enter.
In the "Amount to pay this invoice" field, enter the amount that will reset this invoice.
It it was a partial payment, enter the amount before the faulty payment was made.
If it was paid in full by the faulty payment, enter 0.
Press Enter.
In the "OK?(Y/N)" field, type +P.
Press Enter.
The invoice table won't reflect this adjustment yet, but it has been made. Repeat steps 7 - 9 until all invoices that need to be adjusted have been done.
Hit the Escape key several times to back out until the "Customer code" field is active and press Enter to see the adjustments you've just made.
You can now enter the payment, again.
Create an Adjustment and Force it Paid
This method is used when you just can't identify the invoice or invoices associated with the faulty payment.
The first task is to get the Display Account Detail screen to show the correct balance. We accomplish this by creating a single adjustment, whether it be a credit or a debit.
From Customer Processing, go to Enter Transactions. (Older menus may have this option labeled something like "Enter Charges / Balance Forward Payments")
Enter the Customer Code.
Type is "A" for adjustment.
Date is today.
Code should be "T" unless you want to create a new adjustment code.
Amount should be the total amount of adjustment needed to bring the Display Account Detail screen into balance.
Reference should be "FIX".
Comment should be "FIX"
Once the new invoice has been created, be sure to update your batch.
Now you adjust the Amount Paid for this adjustment invoice.
From Customer Processing, go to Enter Open Item Payments, and enter the customer code.
You should notice that the Balance shown in this screen is now incorrect.
You've fixed the balance in the Display Account Detail screen, so now you'll fix the balance in this screen.
Payment Date is today.
Payment Code is "P".
Reference is blank.
Payment Amount is 0.
Enter the Sequence Number (the number in the first column of the invoice table) of the first invoice to adjust.
Press Enter.
In the "Amount to pay this invoice" field, enter the total amount of the adjustment invoice, whether it be a credit or debit.
Press Enter
In the "OK?(Y/N)" field, type +P.
Press Enter.
The invoice table won't reflect this adjustment yet, but it has been made.
Hit the Escape key several times to back out until the "Customer code" field is active and press Enter to see the adjustments you've just made.
You're done.
This image shows what the TEST account Display Account Detail screen looks like after this method is used to adjust it.
You can see the adjustment invoice and that it's paid in full. You also see that there is no payment associated with this invoice. This was accomplished using 10 - 20, above. Had this been paid as a normal invoice is, a payment would have been generated and the account would still be off.
This image shows that the Customer Aged Trial Balance no longer shows this account as out of balance.
See also
Open Item Payments
.
Article ID
fix_out_of_balance_direct_bill_accounts
Views
2806
Last Modified
12/19/2014 4:19 PM
Copyright © Execu/Tech Systems, Inc. All Rights Reserved.
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##