Information Systems:Periodic-Month - Revision history

Sheilav at 16:48, 14 March 2016

2016-03-14T16:48:19Z

Sheilav: /* Reconcile Totals */

2015-11-30T17:07:26Z

Reconcile Totals

Sheilav: /* Reconcile Totals */

2015-11-30T17:02:50Z

Reconcile Totals

Sheilav: Created page with "=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..."

2015-11-19T19:21:11Z

Created page with "=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..."

New page

=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 ? on 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.

If you are reconciling these on the first of the month, and they are out of balance. Look in SROTRAC - accounting could have an invoicing batch open, and in SROOVF as there may be a journal in error.

← Older revision		Revision as of 17:07, 30 November 2015
Line 52:		Line 52:
	- 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.		- 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]].
−	If you are reconciling these on the first of the month, and they are out of balance. Look in SROTRAC - accounting could have an invoicing batch open, and in SROOVF as there may be a journal in error.

@@ Line 11: / Line 11: @@
 '''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 ??????
+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 [[Balance A/R Reconciliation List]].
  *VA/480B*                   A/R RECONCILIATION LIST
@@ Line 23: / Line 23: @@
 '''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 ??????
+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 [[Balance A/P Reconciliation List]].

@@ Line 38: / Line 38: @@
 '''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 ? on the G/L.
+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.