Modules»General Ledger»Accounting Flow
  • RSS Feed

Last modified on 2/18/2016 3:52 PM by User.

Tags:

Accounting Flow

ORDER PROCESSING:

 

O/E Task 1: Order Entry and Editing

  • Reduces quantity-on-hand in Warehouse Master file (Inventory module)
  • If item is serialized, updates Serialized Master file (Inventory module) to show it has been sold.
  • Updates MTD and YTD dollars sold and quantity sold in Warehouse Master (Inventory module)
  • Nightly back-up routine moves invoiced orders out of Task #1 into Task #2 (Invoiced Order Holding File)

 

O/E Task 2:  Invoiced Order Holding File

  • Print Edit List.
    • Check off and verify with physical invoices, both sales and money (check, cash & credit card) received.
    • Changes may be made to invoices & reprinted.
  • Post Invoices:

    • Prints completed order posting register…..save in a binder or e-mail (if this option is available).

    • Updates:

      • Order History (O/E module)

      • Item History (O/E module)

    • Moves invoices to Sales Entry and Editing file (Task #1 in A/R module), where the invoices will stay in Edit form until verified and posted.  Any cash received will be moved to the Cash Entry and Editing file (Task #2 in A/R module

 

ACCOUNTS RECEIVABLE:

 

A/R Task 1:  Sales Entry and Editing

  • Print/Preview Edit List – information comes from Task #2 (Invoiced Order Holding File) in the O/E module.
    • Make any corrections – order level only, not line item level
    • Enter Debit Memos
    • Enter any other adjustments
  • Post
    • Prints Sales Register….save in a binder or e-mail  (if this option is available).
    • Updates:
      • Customer Master File (A/R module)
      • A/R Open File (A/R module)
      • Sales History file (A/R module)
      • Sales Distribution History file (A/R module)

A/R Task 2:  Cash Entry and Editing

  • Print/Preview Edit list – information comes from Task #2 (Invoiced Order Holding File) in the O/E module.
    • Verify cash (checks, cash and credit cards) amount is the same as brought over from the Invoiced Order Holding File
  • Enter cash/checks, etc.

    • Enter any money received ‘on-account’

    • Enter ‘cash paid out’ of till

    • Enter any ‘miscellaneous’ money received

    • Enter adjustment for money that is ‘short’ or ‘over’.

  • Reprint/Preview Edit list – amount should agree with Bank Deposit ticket.

  • Post

    • Prints Cash Register….save in a binder or e-mail (if this option is available).

    • Updates:

      • Customer Master file (A/R module)

      • A/R Open file (A/R module)

      • Cash History file (A/R module)

 

A/R Task 9:  Aged Trial Balance

  • Information comes from the A/R Open file
    • A/R Open file is the only file which contains both the Sales and the Cash information for each individual customer.
    •  “Paid” invoices should be cleared from the customers records once a month using the program in the A/R System Management Function task.
  • A/R Task 12:  Prepare Monthly Statements
    • Information comes from the A/R Open file. 
  • A/R Task 32:  System Management Functions
    • Clear Paid Invoices from customer records (Task #4)
    • Generate A/R to G/L Interface (Task #3).  Information moves to General Ledger module.
      • Debit column comes from Sales History file
      • Credit column comes from the Sales Distribution file
      • Cash information – both debit and credit comes from Cash History file