This feature, or some fields and options described, might not be available depending on your settings, security rights, or platform package.

Related Topics Link IconR    Related Topics Link IconR

Creating a General Ledger Beginning Balance Journal Entry

Creating a Beginning Balance journal entry is necessary to establish general ledger balances for your agency as of the accounting conversion date. It is recommended that you review the Converting Your Accounting help topic prior to beginning this process.

AMS360 balances for the following accounts can be entered in full detail (Customer/Policy/Invoice):

If you want to enter these balances in full detail, see Creating Beginning Balance Journal Entries:

Click the PDF icon to open and print a General Ledger Beginning Balance Worksheet.

ClosedAccessing the Beginning Balance Journal Entry

When you are ready to begin your General Ledger Beginning Balance, do one of the following:

ClosedGeneral Information Section

When you open the Beginning Balance Journal Entry form, the General Information section is expanded.

Field Name/ Group

What is this?

Business Unit

Field

What is this?

Division

Select the appropriate division from the list.

Separate journal entries must be created for the general ledger balances for each division. Once the division selection is made and you begin entering balances, the division cannot be changed.

If the wrong division is selected, just close the journal entry without saving, and begin again, selecting the correct division.

Journal Date

Enter the date you want the journal entry to post to the general ledger. The date defaults to the current system date but can be changed.

This date is generally the last day of the month prior to your "Live" month on AMS360. Why? This allows you to print financials on AMS360 for...

  • a period that includes only the beginning balances from your prior system.

  • your first month on AMS360 that excludes your beginning balances.

Journal Memo

Enter a description of the purpose for the journal entry. The default is "Beginning Balance Journal Entry".

Totals

These fields are dynamic and update as you add voucher lines to your journal entry. Before you can post the journal entry the following must be true:

  • Debits = Credits

  • Balance = $0.00

Fields

What is this?

Debits

Total debits entered on the journal entry.

Credits

Total credits entered on the journal entry.

Balance

When all balances are entered, the total Debits must equal the total Credits with a Balance of zero in order for the journal entry to post.

ClosedOther GL Accounts Section

  1. Expand the Other GL Accounts section.

  2. Click New to begin your general ledger beginning balance journal entry. The data entry fields appear.

Field Name/ Group

What is this?

GL #

Choose the appropriate account number from the list. If the account number is sub-divided (grouped) by a particular entity, that type of entity in the GL # required fieldswill become active. Select the appropriate entity from the list.

Conversion Account Entries (Subsidiary Ledgers)

Customer, broker and finance company receivables, broker and employee commission payables, and brokerage, fee, and insurance company payables are entered by entity to their applicable conversion accounts when entering GL Beginning Balance Journal Entries.

Why? Because, when you originally entered these beginning balances to the system accounts, you created subsidiary ledgers for these various entities by entering them by division/entity/customer/policy/invoice number. To create a valid journal entry (debits = credits), these balances were then offset to their appropriate conversion (conv) accounts by division/entity in a reciprocal (opposite) amount.

When you enter directly to the system accounts you must enter by entity, by customer. Further delineating your entries by policy/invoice is optional depending on the level of detail you want in AMS360.

Now, during the GL Beginning Balancephase you must enter these balances (totals by division/entity) again, only this time to the conversion accounts. This creates a valid (debits = credits) journal entry AND brings the conversion account balances to $0.00.

Post to Conversion Account Number

Used For:

21138 Conv Commission Payable - Broker Bus

Employee/Broker commission payables - broker business. Enter these balances by division, by employee or broker (Comm Person).

21114 Conv Accounts Payable to Brokerage Co

Brokerage company net payable balances. Enter these balances by division, by brokerage company.

21118 Conv Accounts Payable to Fee Co

Fee company net payable balances. Enter these balances by division, by fee company.

21113 Conv Accounts Payable to Insurance Co

Insurance company net payable balances. Enter these balances by division, by insurance company.

11290 Conv Receivable Differences

Customer, broker, and finance company receivable balances. Enter these balances by division, by customer/broker/finance company.

21134 Conv Commissions Payable - Agency Bus

Employee commission payables - agency business. Enter these balances by division, by employee (Comm Person).

Conversion Account Entries (No Subsidiary Ledgers)

Currently, there is no provision in AMS 360 for entering account balances directly to the system accounts below as a subsidiary ledger.

  • 11241 DB Comm Receivable - Insurance Companies

  • 11242 DB Comm Receivable - Brokerage Companies

  • 21121 DB Deposits Payable - Insurance Companies

  • 21122 DB Deposits Payable - Brokerage Companies

  • 21125 DB Deposits Payable - Finance Companies

When entering GL Beginning Balances enter the balance of these accounts by division to the following accounts:

Post to Conversion Account Number

Used For:

11243 Conv DB Comm Receivable - Insurance Companies

Direct bill receivables that you have billed, but not yet received the commissions from the insurance company. Total all insurance companies by division and enter to this account.

11244 Conv DB Comm Receivable - Brokerage Companies

Direct bill receivables that you have billed, but not yet received the commissions from the brokerage company. Total all brokerage companies by division and enter to this account.

21123 Conv DB Deposits Payable - Insurance Co

Direct bill deposits made on behalf of the insurance company. Total all insurance company deposits by division and enter to this account.

21124 Conv DB Deposits Payable - Brokerage Co

Direct bill deposits made on behalf of the brokerage company. Total all brokerage company deposits by division and enter to this account.

21126 Conv DB Deposits Payable - Finance Co

Direct bill deposits made on behalf of the finance company. Total all finance company deposits by division and enter to this account.

Amount

Enter the balance for the account.

Description

Defaults "GL Beginning Balance" but can be changed, if desired.

Business Unit

Fields

What is this?

Division

The Division defaults from the Business Unit/Division entry in the General Information section, and cannot be changed.

Branch
Department
Group

The Branch, Department, and Group are required for all GL income and expense accounts (account numbers #40000 through #99999).

Depending on how your agency is setup in Agency Setup > Accounting Options, branch and group may not be available.

GL # Required Fields

Required fields are based on the general ledger number selected in the GL# field. When a system account is subledgered (grouped), by one of the entities listed below, you must select the specific entity for that general ledger account balance.

  • Customer

  • Insurance Co

  • Brokerage Co

  • Finance Co

  • Fee Co

  • Vendor

  • Broker

  • Comm Person

ClosedWorkflow: Add General Ledger Account Detail Rows

A detail row must be entered for every account in your source trial balance report that has a balance. To create a detail row:

  1. Click New. The data entry section expands.

  2. Complete the fields for the first general ledger account on your source report. Click Add... Continue entering general ledger balances.

Clicking Add... adds the detail row but does not close the data entry fields. If you click Add, the detail row is added, but the data entry fields close. To continue, you must click New to begin again.

  1. Enter all system account balances by division and in some cases by entity to the conversion accounts. See the Other GL Accounts Section>GL #for more information on this process.

  2. Be sure to enter your total customer, broker and finance company receivables as follows, depending on your agencies accounting basis, and whether you entered late charges on the Creating Beginning Balance Journal Entries:

Accounting Basis

How to Handle

Accrual

Your detailed accounts receivable is entered when you post your Customer Beginning Balance journal entry. These entries post to general ledger accounts #11211, #11221, and #11231.

To balance this journal entry you are required to offset the total receivables balance to account #11290 - Conversion Receivables Differences.

Subsequently, when entering your General Ledger Beginning Balance journal entry, the total receivables amount from your source report must be entered to account #11290 to balance the journal entry and offset (clear) the #11290 account.

Cash

When No Late Charges are Posted on the 'Customer' Beginning Balance Journal Entry:

Follow the instructions for Accrual accounting basis.

When Late Charges are Posted on the 'Customer' Beginning Balance Journal Entry:

Your detailed accounts receivable is entered when you post your Customer Beginning Balance journal entry. These entries post to general ledger accounts #11211, #11221, and #11231.

To balance this journal entry you are required to offset the total receivables balance to account #11290 - Conversion Receivables Differences.

For agencies set up on a Cash accounting basis, the late charge amount designated for account #11290 does not post there, but automatically posts to the deferred late charge accounts by business type.

Account Number

Type of Business

21480   Deferred Late Charge Income - Agency Bus

Agency Business

21490   Deferred Late Charge Income - Broker Bus

Broker Business

Therefore, to balance/clear account #11290, balance the General Ledger Beginning Balance Journal Entry, and post your income correctly, you must:

  • Enter the total receivables amount less late charges to account #11290.

  • Deduct the total late charge amount from your general ledger late charge income account.

    Why?
     Because the total late charges are already posted to the #21480 and/or the #21490 Deferred Late Charge system accounts. As your customers pay the receivable balances, your late charge income will be deducted from the deferred late charge account and posted to the late charge income account at that time.

  1. When you are finished entering all general ledger account balances, the balance in the Totals field should equal zero, indicating the total of all debits entered equals the total of all credits entered. The journal entry will not post until this field equals zero.

  2. ClickPost.