Daily Close #1: Invoice Edit


Back Office Menu -> Daily Close Menu -> Daily Close 1: Invoice Edit

When all the invoices for a day have been entered, run the Daily Close to begin the posting process for this batch of invoices.
Refer to the Daily Close Overview for procedural information and process flow.

Prior to beginning the Daily Close 1, an optional "dry run" can be done using Trial Daily Close: Invoice Edit.
It is useful to review the trial reports so errors and problems can be identified and corrected before the actual Daily Close is initiated.

Field Ticket Processing
The requirement to assign a Field Ticket to every invoice can be activated in the Company Invoice Parameters.

Daily Close Features

Running the Daily Close
The screen displays the number of invoices currently On Hold and the total dollar value.
These could be Sales Approval required invoices or Invoices requiring a P.O.# or they could be held from posting for other reasons.
Refer to Hold/Release Current Invoices for details and to release these invoices when appropriate to post in the next DBR.

The prompts to initiate the Daily Close 1 are:

DIVISION
This prompt only appears if the option to Post DBR by Division is set in the Company Daily Close Parameters.
Enter the correct division or location, or select it from the window.
Note: Posting Daily Close by Division allows different locations or branches to post simultaneously.
DAILY BUSINESS BATCH #
This prompt only appears if the option to Post DBR by Division is set in the Company Daily Close Parameters.
This field defaults to the next Batch # or select the correct Batch # for the range of DBR's required from the window.

If there are any Invoices on Hold for this division a spreadsheet is generated to list invoices in previous batches, with invoice #, customer #, DBR#, and on hold flag.
This is information only and is useful for follow-up on unposted invoices.

As soon as Daily Close #1 is started, any subsequent invoice entered will be added to the NEXT DBR #.
If invoices are entered in lots or bundles, begin entering the next lot even if the current lot is not balanced. This is true, even if Daily Close #2 or #3 has not been run.


DAILY BUSINESS REPORT # __
This prompt only appears if the option to Post DBR by Division is NOT activated.
The current DBR # will display.

Accept this default to post the next DBR#, or over-type with the desired DBR#.
As each invoice is entered, it is assigned to the current DBR (Daily Business Report) Number.

DBR Inquiry
When the feature to Post by Division is not activated, a window is provide to view a summary of DBR's that have been not been completed, with the number of invoices to be posted in each DBR, the number of invoices in each DBR that are flagged on HOLD, and the number of deposits that will be posted in each DBR.
This is useful to identify DBR's that need to be run to post the invoices.

PRINT PAYMENT METHOD DETAIL
This is an optional report, which may be very useful in balancing that cash drawer.
While the Bank Deposit Worksheet indicates the grand totals by division for each Method of Payment, this report provides the details of a particular Method Of Payment if the cash drawer amount does not agree to the Bank Deposit Worksheet.
For each payment method selected, the Detail Report shows the customer name, amount paid, the source - reservation, contract or invoice #.

PRINT CASH BALANCE REPORT
The Cash Control report is optional.
It lists the cash taken in at the counter by the different operators, with document and method of payment information.
The output can be generated in detail or summarized.

Note: This report includes Counter Payments but does not include payments received through the AR department.


CASH RECONCILIATION POST DATE
This date applies to the 'Cash Over / Short' feature activated in the Company Daily Close Parameters.
This G/L posting date for the "Cash Balance" journal transactions generated from the Cash Reconciliation, defaults to today's date but can be reset (usually back dated) to reflect the date the actual bank deposit was made to more accurately match your bank statement.
This date respects Date Range Control for the module GLET.

Finished?
A printer can be selected from the Printer option located on the menu bar at the top of the screen.

Click CANCEL to abort this report and the posting function.

Click the ACCEPT to begin the Daily Close #1. The following reports will print:

  • Held Invoices Without a P.O.# - lists any invoices in the batch requiring a P.O.# that do not yet have one assigned.
    These invoices are put On Hold until a P.O. is assigned and they are released in Hold/Release Current Invoices.
  • Invoice Edit Report - provides a list of invoices entered since the last Daily Close #1.
  • Performance Summary - subtotals the rentals and sales by Product Class.
    (Optional- controlled by flag in Company Daily Close Parameters)
  • Deposits Journal - lists new customer deposits from contracts/reservations.
  • Bank Deposit Worksheet - is a summary of cash receipts and A/R payments by division.
  • Cash Control Report - lists cash amounts taken in by operator in counter transactions with the method of payment, including Counter Payments and excluding AR Payments.
    (Optional- prompt for in DAILY CLOSE 1)
  • Method of Payments Report - provides an analysis by revenue by method of payment.
    (Optional- prompt for in DAILY CLOSE 1)

CASH BALANCING RECONCILIATION
If activated the cash-out screen for this DBR displays.

Setup:

  • This screen only displays if the Cash Over/Short feature has been activated from the Company Daily Close Parameters.
  • An 'Over/Short Default' value can be set in Company Daily Close Parameters that controls whether the outstanding dollar amount to be reconciled is initially displayed::
    • as the Actual Closing Cash until the dollars are moved to the "Deposit Amount" column in the Actual Closing window
    • as fully deposited in the Less Bank Deposits field with the associated the deposit distribution by payment method in the Less Bank Deposits window
    • all dollars taken today displayed as deposited, except for any Ending Cash On Hand carried from the previous day
  • Any payment methods that should or should not be included in the Cash Reconciliation, can be flagged in Method Of Payment Codes, and assigned the relevant Bank Account for posting.
  • Startup values for each payment method can be entered in Reconcile Cash Closing Balances.
  • Payment methods that require a deposit fee such as Credit Cards, can be identified in Method Of Payment Codes where the Expense Percent and Expense Account can be assigned.
                            Cash Reconciliation

Opening Cash:                  100.00      From Invoice#:    5345
                                           To Invoice#:      5373
Customer Deposits Taken:       135.00      # Of Invoices:      25
Total Cash From Invoices:      645.50
Received On Account:          1680.16      Cash Invoices:       645.50
Less Bank Deposits:           2460.66      Account Invoices:    527.80
                             --------                         --------
Calculated Closing Cash:       100.00      Total Sales:        1173.30
Actual Closing Cash:            99.58
                             --------      Customer Deposits:  1355.00
Cash Over/Short Amount:           .42-     Previous Day:       1306.10

Print Reconciliation Report:


DBR Invoice and Deposit Information
On the right on the screen the DBR information is display only and cannot be changed here.
This includes:
FROM INVOICE#
This is the first invoice included in the DBR.
TO INVOICE#
This is the last invoice number included in the DBR.
# OF INVOICES
The total number of invoices included in the DBR is displayed.

CASH INVOICES
The total amount of paid invoices in this DBR is displayed.
This figure does include invoice amounts actually paid by deposits previously taken on the Contract, Reservation, or Order.
ACCOUNT INVOICES
The total dollar amount for invoices charged On Account, from this DBR is displayed.
TOTAL SALES
The sum of the Cash and On Account invoices is displayed.

CUSTOMER DEPOSITS
This value represents the total value of all deposit amounts currently being held.
It is calculated as the previous accumulated deposits plus deposits from this DBR, less deposits used in this DBR.
PREVIOUS DAY
This is the total accumulated deposit amount at the end of the last DBR.

On-Screen Cash-Out
Use the left side of the screen to agree the actual amounts taken, with the totals from the DBR for each method of payment.
OPENING CASH
The total opening Cash On Hand in the cash drawer displays as of the start of the DBR.
Window to view the breakdown by payment method. These values cannot be changed.

Note: To enter the first start-up values use Reconcile Cash Closing Balances.


CUSTOMER DEPOSITS TAKEN
The total deposits taken on Contracts, Reservations, and Sales Orders, displays. This value cannot be changed.
Window to view the breakdown by payment method.
Window again on the "Amount" field, to view the division, operator, deposit source, document#, amount for each deposit, and customer name.

TOTAL CASH FROM INVOICES
The total amount received for payment on invoices that have NOT been charged On Account, displays.
Window to view the details by payment method.
Window again on the "Amount" field, to view the division, operator, deposit source, document#, amount and customer name.

RECEIVED ON ACCOUNT
The total amount received as payments in A/R or from the Counter against customer accounts, is displayed only if the flag to Include Customer Payments In The DBR is set in the Company Daily Close Parameters.
Window to view the details by payment method.
Window again on the "Amount" field, to view the division, operator, deposit source, document#, amount, and customer name.

Note: Current Counter payments display as they are posted with the Daily Close, but A/R payments are only included if they have been posted since the last Daily Close 1 was run.


LESS BANK DEPOSITS
Initially this field displays as zero, unless the Over/Short Default default value in the Company Daily Close Parameters is set to the Deposit Amt option, and then the amount initially displayed in this field shows the Opening Cash as fully deposited, with the associated the deposit distribution by payment method in the Less Bank Deposits window.

Window to access the DBR receipts detail by Method of Payment, and to enter the actual amounts to be deposited in the bank and the actual amounts to be left On Hand (e.g. in the Cash Drawer).
The prompts are:

METHOD
The method of payment code displays per the codes setup in Method Of Payment Codes.

DESCRIPTION
The method of payment description displays.

DEPOSIT AMOUNT
Enter the amount to be deposited in the bank for each method of payment.
The G/L clearing account to be credited and the G/L bank to be debited are determined in Method Of Payment Codes.

Note: When the deposit amount is entered, the Over/Short is automatically updated to reflect the change.


ENDING CASH
This is the calculated ending cash on this DBR for this payment method, after the Deposit Amount is entered.

CASH ON HAND
Enter the dollar amount for each method of payment that is to be left On Hand after the deposit is made. (e.g. amount left in the Cash Drawer)
This dollar amount becomes the Opening Cash balance on the next DBR.

Note: When the cash left On Hand is entered, the Over/Short is automatically updated to reflect the change.


OVER/SHORT
The dollar amount over or under is displayed.
This is the difference between the calculated amounts from the DBR information, and the amounts just entered for the bank deposit and for the cash to be left On Hand.
A window is provided to view the amounts used in the Cash/Short calculation.

EXPANDED RECORD
Click EXP/CON to view any Expense % fee and the actual amount that is paid, when the deposit for this Credit Card is made. This amount is calculated as a percent of the deposit amount for this method of payment.
The percent and posting expense account are setup in Method Of Payment Codes.

Account Errors:
If any of the G/L Bank or Clearing accounts in Method Of Payment Codes or the Cash Over/Short accounts in Default Accounts, are missing or invalid, a warning for that payment method will be displayed at the bottom of the screen.
The DBR will not be accepted until these G/L accounts are provided correctly.


CALCULATED CLOSING CASH
The total cash at closing less the bank deposit is displayed per the DBR information and calculations.

ACTUAL CLOSING CASH
Initially this field displays as zero, unless the Over/Short Default default value in Company Daily Close Parameters is set to the Actual Cash option, and then the initial amount displayed in this field defaults from the Opening Cash, and the value in the Less Bank Deposits is zero instead.
Amounts change to reflect the amounts entered for deposits and cash on hand in the window on the Less Bank Deposits field.

When the reconciliation is finished, if this Actual Closing Cash amount is not correct, window to re-access the DBR receipts detail by Method of Payment, and confirm or re-enter the actual amounts to be deposited in the bank and the actual amounts to be left On Hand (e.g. in the Cash Drawer).
This window is the same window that is accessed and explained in the Less Bank Deposits field.


CASH OVER/SHORT AMOUNT
As amounts are reconciled in the Less Bank Deposits window, any Cash discrepancy between actual closing cash and the calculated closing cash, is displayed as the Over/Short Amount, where any cash shortage or under, displays with a negative sign.

When the DBR is accepted, the Cash Over/Short Amount posts to the expense account assigned by currency in Default Accounts.


PRINT RECONCILIATION REPORT
A printer can be selected from the Printer option located on the menu bar at the top of the screen.
Check this checkbox to generate:
  • the Reconciliation report
  • the Bank Deposits detail that summarizes the reconciliation information by payment type
  • the Deposit report by customer for only the payment methods flagged to "Include in Bank Deposit Report" in the Bal GL window of the Method Of Payment Codes table

Uncheck this box to skip the optional Reconciliation report. The prompt "Report Totals OK" will also be skipped then.


Finished?
Click ACCEPT at the bottom of the screen to continue with the DBR, or click CANCEL to abort.

REPORT PRINT OK
Click YES in the pop-up confirmation dialogue box if the Cash Balancing report printed successfully.
This accepts the DBR, moves the invoices to Batch, and generates the postings to the banks, the clearing accounts, the Credit Card fees, and the Cash Over/Short.
These cash reconciliation posting transactions print and post with the "Rental Journal Transactions" from Daily Close 3
After the Cash Reconciliation report is accepted, it can be reviewed and reprinted only from Review Cash Reconciliation.

Click NO to prevent accepting the bank deposit, cash clearing, and cash over/short transactions.
The DBR posting is aborted.
This DBR must be re-run from DAILY CLOSE 1: INVOICE EDIT, and the "Cash Balance" report must be accepted, before the next DBR can be run.

Note: Permission to accept and post can be controlled by the Security Roles defined for the operator in Operators, and required for Daily Close 1 (RDIH10B) as set in Module Passwords.


REPORT TOTALS OK
This prompt only appears if the On-Screen Cash-Out option is NOT used, or if the "Reconciliation Report" is printed.

Click NO if changes or corrections are required.
To make corrections, review the invoice using Miscellaneous Invoices or Point Of Sale Invoices. If deposit corrections are made, any corrections or adjustments do not post until the next DBR, unless the deposit correction is "moved" back using the Update Deposit DBR# utility.
After completing the corrections, re-run Daily Close 1 with the same DBR# as the first edit.
The DBR# now displayed during Daily Close #1 will be for the next lot, so over type this with the correct DBR number.

Click YES if the invoice totals are correct. By accepting the Report Totals, the invoices from this DBR will be moved from CURRENT to BATCH, meaning that the invoices will no longer be accessible for corrections or changes.
All invoices in the BATCH will be eligible to be posted in Daily Close #2 and #3.

Once the Daily Close has been accepted, that specific DBR # cannot be reprinted from here.
It can be reprinted from Reprint Daily Business Reports.

Posting Control Daily Close #1
The Daily Close Invoice Edit program is designed to be run by one operator at a time per division/location.
If your company Posts DBR by Division, set the prompt in the company Company Daily Close Parameters. This allows different branches to post simultaneously.
Locking will occur if another operator attempts to run the program at the same time, or if the first operator did not exit the posting program correctly.
A Posting Control Information warning will appear on the screen preventing the second operator from proceeding, and only operators with Security Role permission to reset the Daily Close 1 - Invoice Edit flag will have access to the RESET button that unlocks the program.
Whenever the posting control flag for Daily Close 1 is reset, a record is written to the Delete Log for the Function RDIH50A.

Refer to Daily Close 1/2/3 Process Locks for further status on GLPF locks for this function.

Locking will occur whether Post DBR By Division is on or off.
If it is on, only specific divisions get locked by Daily Close #1, and if it is off the all divisions get locked by Daily Close #1.

Post Customer Payments will also lock the Daily Closes and a locking message will be triggered.


Topic Keyword: RDIH10
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)