Please enable JavaScript to run this help system!
Execu/Tech Systems, Inc.
Knowledgebase
Search:
850-747-0581
Email
Website
Contents
Index
Search
Page Properties
Page Keywords
Page Visibility
Preview For Mobile Device
Lightbox Code & Preview
Save
Cancel
Saving...
Welcome
What's New
System Requirements
Computer Hardware
Other Hardware
Operating Systems
Windows XP Support Ends
Server 2003 Support Ends
Windows 7 Support Ends
Server 2008 Support Ends
TLS 1.2 Requirements
Data Security
Firewall Settings
Credit Card Interfaces
Software Installation
Installation Checklists
Software Installation - Server
Software Installation - Client
Software Reinstall / Move
Create Shortcut Manually
Software Updates
Software Update Requirements
Software Updates
Running ETUpdate from update.zip
Software Update without download
Post-Update Requirements
Questions and Answers
Common Questions
Common Mistakes
Sending a Screen Shot
Recording step by step
Glossary
Data Flow
Execu/Tech Services
Execu/Suite Hotel PMS
Setup Execu/Suite Hotel PMS
Preparation/Installation
Data Preparation
Your Company Setup
Zip Code Database
License Access Code
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
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
System Maintenance
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
Thank-you emails
Enable PDF Saving
Hotel Logo
Import Rate Spreadsheets
Master Folios
MENUINI.FIL Configuration
Terminal ID Number Codes-Batch Terminals
Hotel Print Settings
ETHTMLPrint (Print Folios, Reg Card, Cancellation, etc.)
Procedures Execu/Suite PMS
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
Night Audit Report Viewer
Folio Detail Export
Clearing Adv. Deposits Remaining
Guest History
Manager Reports
Manager Procedures
Adjusting Statistics-AM Report
Other Manager Tasks
Merging profiles
Travel Agency Processing
Travel Agency Setup
Travel Agency Reports
Travel Agency Checks
Assign Master Folio to Guest or Group
Report Generator
How-To Videos and Tutorials
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
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
Execu/Suite CRS
Initial Setup
Menu and Navigation
Rooms Setup
Inventory & Availability
Viewing Inventory & Availability
Default Inventory
House Inventory
Periods of Closure
Events and Groups
Room Type Variations/Adjustments
Stop Sale Limits
Availability by Rate Category
Availability by Channel
Allotments
Booking Rules & Closure Date Rules
Calendar quick changes
Minimum Stay Policies
Automated Revenue Rules
Occupancy Rules
Channel / IDS Rules
Products/Rates Setup
Payments - Cancellations
Groups
Setup
Booking
Lookup
Channel Manager
Corporate Client Setup
Services Setup
Marina and RV Settings
Interfaces
OTA / HTNG
OTA / HTNG Installation and Configuration
OTA / HTNG 2 Way Push
OTA / HTNG 1 & 2 Way Pull
OTA / HTNG Functions and Limitations
OTA / HTNG PMS Settings
OTA / HTNG ROH (Run Of House)
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
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)
FUEL sales in POS
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
Credit Card Processing
EMV Credit Card Processing
Shift4 Credit Card Processing
Shift4 Card Readers (Non-EMV)
Magtek Programming
Shift4 Data Flow
Shift4 Installation
Shift4 UTG Install
Shift4 EMV Setup
Shift4 AuthToken, AccessToken, AccessBlock
Shift4 PMS/POS Setup (MENUS4CO)
Shift4 PMS/POS Setup (Payment Codes)
Shift4 PMS/POS Setup (Other Settings)
Shift4 i4Go V2
Shift4 i4Go V2 Requirements
Shift4 i4Go V2 PMS / POS Settings
Using Shift4 i4Go
Shift4 i4Go V2 Internet Explorer Trusted Zone
Shift4 i4Go V2 Errors
Shift4 Receipt Printer Setup
Shift4 Troubleshooting
Shift4 UTG IP Address and Port
Shift4 Error Codes
Test Shift4 UTG Connection with Telnet
Shift4 Fix (June 19, 2020)
WorldPay Credit Card Processing
WorldPay Critical Setup Info
WorldPay EMV PIN Pad Setup
WorldPay EMV Cloud Config
WorldPay EMV Failure Messages
WorldPay EMV PIN Pad Troubleshooting
WorldPay EMV Data Flow
WorldPay (Non-EMV) Data Flow
WorldPay 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
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
Error: 80040154
Find Software Application Folder
Folio Stops Printing (HTMLPRNT.EXE)
Forms Print to Wrong Printer
Forms Print Too Large
Memory Access Violation
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 Errors
Slow / Stuck Software
Start Program Missing
Support File Uploader
Unable to Select Printers
User Account Control (UAC)
What's My Terminal Number?
Execu/Vault
Remote Connection (RemoteET)
Uninstall Old Remote Connection App
Sample Reports
Year-End Procedures
Fiscal Year
Master Folios Year-End
Seasons and Rates
Year-End Advance Deposits
Server and System Health
PCI Compliance
City Ledger - Direct Bill
General Ledger
Accounts Payable
Payroll
Backup and Storage
Training
New Modules
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
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
Execu/Spa
Execu/Suite Activities
Software Launcher
Search
:
Index
Bookmark
Print This Article
Login
Edit Page
Publish Draft
Delete Draft
Compare Draft
Edit Header
Home
>
Back Office
>
General Ledger
>
GL Setup
SETUP
should be done as follows.
First you will set up the
Control Record
. This determines your fiscal year, current and prior-year P&L accounts, department designations, and earliest posting date. You must create the control record first.
Next you will set up your
Chart of Accounts
. Your Execu/Tech Back Office system comes with a sample Chart of Accounts, You can edit and use this one, or we can clear it completely and you can start with a new chart of accounts. We can import your chart of accounts from a CSV spreadsheet. There may be a charge for this, depending on your data format and whether any conversion is required.
You will format your Balance Sheet and Profit & Loss (Income) Statement as you set up your
chart of accounts
.
Next you can create templates for
Recurring Journal Entries
. This saves time in transactions you post on a regular basis, such as bank fees or transfers. This is not for transactions created automatically by the system such as accounts payable postings, condo owner expenses, or accounts receivables charges such as membership billing. Each of those modules will create the GL entries for you.
If you have multiple profit centers and more than one General Ledger company, you can set up
Inter-company transfer accounts
. This is used with Accounts Payable and not for transfers from one company to another. This allows you to use one company's funds to pay A/P invoices from another company. This will be followed by journal entries which you can post manually or via the Recurring Journal Entries function.
Once you have completed the General Ledger, you are ready to
interface GL to other Execu/Tech programs
such as Execu/Suite PMS, Execu/Touch POS, Condo, and Inventory Control.
Make sure your Execu/Tech Terminal ID is unique based on the information here:
Terminal ID Number Codes-Batch Terminals
.
General Ledger Control Record
Go to Back Office - General Ledger - General Ledger Processing. Your menu may be a little different.
From the GENERAL LEDGE RPROCESSING menu select #5, set-up control record.
Your screen will look similar to this:
Fields 1 through 12
set the beginning of each period and set your fiscal year. If your fiscal year starts October 1, for example, you would enter 1001 in field 1 and continue for the next twelve periods. These fields are required.
Field 13
is for the account number your prior year profit or loss. This account is used internally for the system to calculate prior years profit and loss using the figures from your income and expense accounts. You should NOT post anything to this account. This might not be your "retained earnings" account. This field is required.
Field 14
is for the account number for your current year profit and loss. This account is used internally for the system to calculate the current year's year profit and loss using the figures from your income and expense accounts. You should NOT post anything to this account. This field is required.
Field 15
is optional and is where you can designate the earliest posting date allowed. For example, after you have closed out a year, you can put the day following that year's ending date as the earliest date you will allow new transactions to post.
Field 16 is
used to determine where, in the account number, you are designating departments. This is optional. Each account number can be up to ten characters and may contain letters, numbers, or characters. The department designation can be at the beginning, end, or in the middle.
In the example below, the two characters after the "." designate the department. The 6th character is the beginning position and the 7th character is the ending position. Note that the "." is considered a character.
Using departments:
Field 17
should be left blank.
When your cursor is back at the bottom of the screen, type a number to go to that field or type Y to save the information.
If you will use General Ledger in more than one company, you will need to set up your chart of accounts in both/all companies. If the account numbers will be the same, you can select "Copy Chart of Accounts from Model" located on the General Ledger menu.
BACK TO TOP
General Ledger Chart of Accounts
You can use the sample chart of accounts that came with your system and edit it to suit, or you can create a new chart of accounts from scratch. We can import your chart of accounts from a CSV spreadsheet. There may be a charge for the import, depending on the file format and whether conversion is required.
To set up your General Ledger Chart of Accounts, Go to Back Office - General Ledger - General Ledger Processing. From the General Leger Processing menu, select Account setup.
You will set up asset accounts, liability accounts, income accounts, and expense accounts. You also will set up accounts for report formatting, including comments and totals. Each account type is described below.
The account number can be up to ten characters and may be letters, numbers, and characters. The coding is case sensitive, so capital letters are not the same as lower case letters. The account number is the record "Key" and cannot be changed. The description can be changed.
To use departments, see
Control Record Setup
for explanation.
ASSET ACCOUNTS
LIABILITY / EQUITY ACCOUNTS
INCOME (REVENUE) ACCOUNTS
EXPENSE ACCOUNTS
REPORT COMMENTS / HEADERS / PAGE BREAKS
REPORT TOTAL LINES
BUDGETS
ASSET ACCOUNTS:
Above is an example of an asset account. The description may be whatever you wish, up to 30 characters. The account type will be 1. Typically an asset account is a debit account but your accountant can advise you if it should be otherwise.
You can have up to three report formats, designated by Print sequences 1, 2, and 3 (Fields 4, 5, and 6). You need at least one print sequence so that you can print your balance sheet. Print sequence numbers for balance sheet items (account types 1 and 2) may be 0001 through 4999. The sequence determines where it prints on the report. For example, sequence 1004 will print before 1010. If two or more accounts share the same print sequence, the sum of the two will print on the report. An account with no print sequences assigned will not print. When possible, save a few numbers between each print sequence so that you can insert accounts later. For example, if you assign 1010 to the first account and then 1015 to the next account, you have 1011 through 1014 to insert later.
When your cursor is at the "Ok?" prompt, type Y to save the information. Type the field number to return to a field if you wish to make a change.
LIABILITY/EQUITY ACCOUNTS:
Above is an example of a liability account. An equity account will be set up the same. The description may be whatever you wish, up to 30 characters. The account type will be 2. Typically liability and equity accounts are credit accounts but your accountant can advise you if it should be otherwise.
You can have up to three report formats, designated by Print sequences 1, 2, and 3 (Fields 4, 5, and 6). You need at least one print sequence so that you can print your balance sheet. Print sequence numbers for balance sheet items (account types 1 and 2) may be 0001 through 4999. The sequence determines where it prints on the report. For example, sequence 2004 will print before 3000. If two or more accounts share the same print sequence, the sum of the two will print on the report. An account with no print sequences assigned will not print. When possible, save a few numbers between each print sequence so that you can insert accounts later. For example, if you assign 2010 to the first account and then 2015 to the next account, you have 2011 through 2014 to insert later.
When your cursor is at the "Ok?" prompt, type Y to save the information. Type the field number to return to a field if you wish to make a change.
INCOME ACCOUNTS:
Above is an example of an income account. The description may be whatever you wish, up to 30 characters. The account type will be 3. Typically an income account is a credit account but your accountant can advise you if it should be otherwise.
You can have up to three report formats, designated by Print sequences 1, 2, and 3 (Fields 4, 5, and 6). You need at least one print sequence so that you can print your Profit & Loss (Income) Statement. Sequence numbers for P&L items (account types 3 and 4) may be 5000 through 9999. The sequence determines where it prints on the report. For example, sequence 5001 will print before 5004. If two or more accounts share the same print sequence, the sum of the two will print on the report. An account with no print sequences assigned will not print. When possible, save a few numbers between each print sequence so that you can insert accounts later. For example, if you assign 5010 to the first account and then 5015 to the next account, you have 5011 through 5014 to insert later.
When your cursor is at the "Ok?" prompt, type Y to save the information. Type the field number to return to a field if you wish to make a change.
EXPENSE ACCOUNTS:
Above is an example of an expense account. The description may be whatever you wish, up to 30 characters. The account type will be 4. Typically an asset account is a debit account but your accountant can advise you if it should be otherwise.
You can have up to three report formats, designated by Print sequences 1, 2, and 3 (Fields 4, 5, and 6). You need at least one print sequence so that you can print your Profit & Loss (Income) Statement. Sequence numbers for P&L accounts (account types 3 and 4) may be 5000 through 9999. The sequence determines where it prints on the report. For example, sequence 7004 will print before 7010. If two or more accounts share the same print sequence, the sum of the two will print on the report. An account with no print sequences assigned will not print. When possible, save a few numbers between each print sequence so that you can insert accounts later. For example, if you assign 7010 to the first account and then 7015 to the next account, you have 7011 through 7014 to insert later.
When your cursor is at the "Ok?" prompt, type Y to save the information. Type the field number to return to a field if you wish to make a change.
HEADINGS / COMMENTS (used for report printing):
Above is an example of comment or heading account. No transactions post to this account, but it must exist in order to print on the Balance Sheet or Profit & Loss (Income) Statement. The description may be whatever you wish, up to 30 characters. To create an extra line on the report, create a comment account, but leave the description blank. Typing P in description will create a page break.
The account type will be C.
You may leave the Debit/Credit field blank for comment / heading lines.
You can have up to three report formats, designated by Print sequences 1, 2, and 3 (Fields 4, 5, and 6). You need at least one print sequence so that you can print your balance sheet. Balance sheet items (account types 1 and 2) may be 0001 through 4999. P&L (Income) Statement items (account types 3 and 4) may be 5000 through 9999. The sequence determines where it prints on the report. For example, sequence 2004 will print before 2010. An account with no print sequences assigned will not print. When possible, save a few numbers between each print sequence so that you can insert accounts later.
When your cursor is at the "Ok?" prompt, type Y to save the information. Type the field number to return to a field if you wish to make a change.
TOTALS (used for report printing):
Above is an example of a "Total" account. No transactions post to this account, but it must exist in order to print on the Balance Sheet or Profit & Loss (Income) Statement. The description may be whatever you wish, up to 30 characters.
The account type will be T. After you type "T" your cursor will move to the "Total level" field. Type 1 to 9 for the total level for this record. Grand totals would be the higher numbers, sub totals would be the lower numbers. For example, you might use Total Level 5 for the sum of Level 4 subtotals. Your Grand Total might be Level 9.
You should type D or C in the Debit / Credit field as appropriate to the type of total you are creating.
You can have up to three report formats, designated by Print sequences 1, 2, and 3 (Fields 4, 5, and 6). You need at least one print sequence so that you can print your balance sheet. Balance sheet items (account types 1 and 2) may be 0001 through 4999. P&L (Income) Statement items (account types 3 and 4) may be 5000 through 9999. The sequence determines where it prints on the report. For example, sequence 2004 will print before 2010. If two or more accounts share the same print sequence, the sum of the two will print on the report. An account with no print sequences assigned will not print. When possible, save a few numbers between each print sequence so that you can insert accounts later. For example, if you assign 1010 to the first account and then 1015 to the next account, you have 1011 through 1014 to insert later.
When your cursor is at the "Ok?" prompt, type Y to save the information. Type the field number to return to a field if you wish to make a change.
ENTERING BUDGETS:
Budgets apply to Profit & Loss (Income) Statements and may be set for Type 3 and Type 4 accounts.
When you type B into the "Ok?" prompt and press Enter, a menu will display allowing you to create equal monthly budget amounts or a budget per month.
If you select "Equal Monthly Budget Amounts" a popup will prompt for the annual amount.
The amount you enter will be divided by 12 for each monthly budget.
If you select "Different Monthly Budget Amounts" your cursor will go to each field so that you can enter the budget for that month.
BACK TO TOP
When you have completed setup of your chart of accounts, you should print the following reports to make sure there are no errors and that you like the way it looks.
Chart of Accounts
Balance Sheet
Profit and Loss Statement
General Ledger Recurring Journal Entries
You can create templates for recurring journal entries so that you do not have to post recurring transactions manually.
Go to Back Office - General Ledger - General Ledger Processing - "Set up recurring journal entries".
At the prompt, enter the name of the template. The example below is for bank fees.
Enter the GL Account code, the Journal code to post, the posting date, the amount, and an optional Reference and Comment.
When entering the amount, type a minus sign if it should post as a credit; omit the minus sign if it should post as a debit.
You may enter as many transactions as you wish in any template. Remember to create both the debit and credit transactions.
After you select "Post entries" you will see three popups:
Here is what the transactions look like in the batch, after posting.
To an the existing template, Type
L
and press Enter or click Look-up.
Select the template from the list.
The template will display, allowing you to make changes.
To set the same posting date for all lines, click "Set posting date".
The new date will show up.
Change the amounts, references, and comments if appropriate. Remember to type a minus sign to create credit postings.
When you are finished, select "Post entries".
BACK TO TOP
Reminder:
After you have posted the journal entries, update the GL batch. Go to Print and Update Transaction Batch from the General Ledger menu.
Inter-company transfer accounts
You will use this feature only if you have more than one General Ledger company and you wish to split one A/P payment between banks in two or more GL companies. For example, if you owe ABC Company $500 and wish to pay $200 from Company 01 and $300 from Company 02, then you would use this feature. Note that most properties do not do this. The A/P system will transfer monies from each designated company into the company where you process A/P. When you create the A/P invoice, the expense/liability will post into the company designated when you create the invoice.
The credit (accounts payable) postings will be in the company in which you are processing A/P. When you pay the invoice, the GL A/P debit will post into the A/P company in which you are processing A/P. The G/L bank credit will post to the GL account designated in the A/P Control Record and selected during "Print Checks". Additional transactions will post according to how you have set up the Inter-company transfer accounts configuration. A GL debit will post to the GL account for the TO company and a GL credit will post to the GL account for the FROM company.
GL accounts must exist in both companies. They do not have to be the same account numbers. If they should be the same you can run "Copy Chart of Accounts from Model", located on your General Ledger menu.
In the following example, a $500 A/P invoice will be created in Company 01 and paid from Company 01. Expenses will be split between Company 01 and Company 02. Money will be transferred from Company 02 into Company 01 to pay for Company 02's portion of the invoice. Although processing is not covered in this "setup" section, we are including it so that setup will make more sense to you.
Go into the Company from which you will create and pay A/P invoices. This is the company that the money will be transferred TO. If you will be processing A/P from more than one company and need inter-company transfers for funds, do this from each Company.
From your General Ledger Processing menu, select "Inter-company transfer accounts".
In the following images,
Company 01
is indicated in
blue
and
Company 02
is indicated in
re
d
.
The above was done in Company 01, where A/P is going to be processed.
The "Offset Company" is the company to transfer money FROM. In the above example, money will transfer from Company 02 into the current company, which is 01.
Next, enter the G/L account number to transfer the money TO, in the current company. It can be the bank account you will pay the invoice from or it can be a different account from which you will manually transfer the money into the bank account. If you are using different companies you can use Recurring Journal Entries if you wish.
Next, enter the G/L account number to transfer the money FROM, which will be in the Offset company. It can be the actual bank account or a different G/L account. If it is a different account, you will want to create manual transactions in both the bank account and the transfer account. If you are using different companies you can use Recurring Journal Entries if you wish.
When you get to the "OK?" prompt, type Y and press Enter.
That is all you need to do to set up the transfer accounts.
The images below show what happens when you create and pay an A/P invoice.
The A/P invoice above is in Company 01. Note that in the "Invoice distribution", 200.00 was entered for Company 01 and 300.00 was entered for Company 02. Both are going to the expense account for advertising. As you create the invoice you will designate the G/L expense, liability, or other account, and the amount of money to each account, in each company.
Now you are ready to pay the invoice. Below is the GL batch showing the invoice and payment.
The image above shows:
The A/P credit of $500.00 into Company 01 for the invoice entry and a debit of $500 in Company 01 for the payment of the invoice.
The debit to expense of $200 into Company 01 and $300 into Company 02.
The credit of $500 to the Company 01 bank account when the check was paid.
"INTER-COMPANY TRANSFERS" shows the amount debited in Company 01 and credit in Company 02. Remember, the funds were transferred From 02 and TO Company 01 in our example.
Here is the General Ledger detail of both companies for all G/L accounts related to this transaction.
Company 01:
Note that I can now manually transfer the funds from GL Account 1000 into GL Account 1001 if that is what I wish to do. Alternatively, if you set the inter-company transfer account to the actual bank account you do not need to do this step.
Company 02:
BACK TO TOP
Helpful Hint:
To make sure you have set this up correctly, you might set up a dummy A/P vendor account, create an A/P invoice, pay the invoice, then update the batch. Print the GL detail from both companies to see where everything ended up.
Assigning GL Codes to Execu/Tech Programs
The following links will aide you in making sure you have attached GL codes to your Execu/Tech applications.
*
Execu/Suite PMS - Hotel Charge Codes
*
Execu/Suite PMS - Hotel Payment Codes
*
Execu/Touch POS - Revenue Departments
*
Execu/Touch POS - Payment Codes
*
Execu/Touch POS - Discount Codes
*
Execu/Touch POS - Store Record
*
Inventory Control
*
Condo Processing
*
Accounts Payable
*
Accounts Receivable
*
Payroll
NOTE: Exec/Touch POS interface only needs to be set up for stand-alone POS for customers not using Execu/Suite Hotel PMS.
BACK TO TOP
Click
HERE
to see the previous Back Office manual.
Email
us if you would like a quote for on-site or remote training.
Related Files
none..
Related Pages
none..
Article ID
gl_setup
Views
3635
Last Modified
8/8/2017 2:14 PM
Copyright © Execu/Tech Systems, Inc. All Rights Reserved.
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##