Information Systems:Periodic-Month

Month

Invoices for Miscellaneous Carriers

Gerald keys these into a spreadsheet, then sends it once a month to I.T. The instruction on how to do this are in Carrier Interface#Other Carriers

Finance Reports

Reconcile Totals

A/R Reconciliation

This is the first spool file FSR297P. The A/R amount should equal the G/L amount; the difference should be zero. If not, see ??????

*VA/480B*                   A/R RECONCILIATION LIST
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -                     A/R   AMOUNT    A/R AMOUNT      G/L AMOUNT      G/L AMOUNT      G/L AMOUNT       DIFFERENCE   
Main Grou Subg Cost Temp intrupt(a) Balance amt (b) Temp intrupt(c) Balance amt (d) Journal maint(e) Diff ((a+b)-(c+d+e)) 
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
120000                                6,553,021.93                    6,553,021.93  
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
Grand total                           6,553,021.93                    6,553,021.93  

A/P Reconciliation

This is the second spool file FSR297O. The A/P amount should equal the G/L amount; the difference should be zero. We are out by 4 cents, and cannot correct it. Strangely enough, this difference is caused by exchange on an old IBS invoice. If this is not out by 4 cents, see ??????

*VA/480B*                   A/P RECONCILIATION LIST 
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
                    A/P   AMOUNT    A/P AMOUNT      G/L AMOUNT      G/L AMOUNT      G/L AMOUNT       DIFFERENCE
Main Grou Subg Cost Temp intrupt(a) Balance amt (b) Temp intrupt(c) Balance amt (d) Journal maint(e) Diff ((a+b)-(c+d+e))
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
210000                                6,601,215.09-                   6,601,215.09- 
210025                                1,354,314.64-                   1,354,314.60-                                 0.04-
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Grand total                           7,955,529.73-                   7,955,529.69-                                 0.04-

Unmatched Receiving (or Unmatched PO's)

This is the first, and longest, spool file QPQUPRFIL. This is the detail and totals of remaining amounts on file SROGRT. Which is goods we have received, but not yet been invoiced for. The totals on this should agree with the G/L.

- Order type MO is manual orders, and is in G/L number 210050, but will not be the same because of the way the transaction type is set up. 210050 is both debited and credited when the goods are received, and when they are invoiced.

- Order type RT is returns to vendor, and is in G/L number 210300.

- Order type CS is car stock, and is in G/L number 210500.

- Order type RE is receiving error, and is in G/L number 220050.

- Order type BE is price variance to be changed to head office, PV is price variance to be charged to rep, and QV is quantity variance. They are in G/L number 210625. This is the hardest account to reconcile, as invoicing will be included with the PO or PE that had the original issue.

- Order type PE is EDI purchase orders, PO is regular purchase orders, and XF is reference purchase orders. They are in G/L number 220000.

For more information on balancing this report, see Balance Unmatched PO's.