Accounting Finance:AMEX POS Reconciliation - Revision history

Rickyz: /* AMEX Reconciliation Worksheet Procedures */

2017-11-09T20:25:45Z

AMEX Reconciliation Worksheet Procedures

2017-11-09T20:12:37Z

AMEX Reconciliation Worksheet Procedures

2017-11-09T20:07:48Z

AMEX Reconciliation Worksheet

2017-11-09T20:01:07Z

2017-11-09T19:57:05Z

2017-11-09T19:53:53Z

CIBC AMEX Bank Statement & Visa/MC Transfers

2017-11-09T19:53:01Z

CIBC AMEX Bank Statement & Visa/MC Transfers

2017-11-09T19:52:40Z

2017-11-09T19:51:18Z

2017-11-09T19:47:46Z

GL 100100 Summary Report

@@ Line 70: / Line 70: @@
 #By the '''Reconciliation''' cells, enter the value of the prior month adjustment under ''Bank -> Current adjustments''. Enter the value of the current month adjustment under ''G/L -> Current Adjustments''. Enter Past adjustments under ''G/L -> Past Adjustments''
 #After confirming all amounts under '''discount charges''', create a manual invoice for each store, using item number 02081271. Record the invoice number under the associated column and send manual invoices to each store.
 [[Category:Workflows-Finance]]

@@ Line 69: / Line 69: @@
 #Fill in the balances, deposits and transfer amount in the yellow cells below. Past Adjustments can be found on the G/L Printout, using the sum of credits excluding amount for Total Discount Charges.
 #By the '''Reconciliation''' cells, enter the value of the prior month adjustment under ''Bank -> Current adjustments''. Enter the value of the current month adjustment under ''G/L -> Current Adjustments''. Enter Past adjustments under ''G/L -> Past Adjustments''
 [[Category:Workflows-Finance]]

@@ Line 62: / Line 62: @@
    Compare the data from the two printouts and note any discrepancies.
-==AMEX Reconciliation Worksheet==
+==AMEX Reconciliation Worksheet Procedures==
 #Enter the ending balances from the G/L and the Bank Statement into associated cells
 #Copy over the list of stores following the existing format along with its associated discount charges. This will total up to the discount charges for the month. Leave a note to Nancy to move this sum to G/L 220154
 #Below the Discount charges Sum, note any discrepancies. A good rule of thumb is to include any non-timing issue related differences between the '''CIBC AMEX printout''' and the '''Visa & MC Transfers''' printout. As well, include discrepancies arising from ''future'' timing differences. Look to the G/L printout for any discrepancies that might help balance the Bank Balance to the Adjusted G/L Balance
 [[Category:Workflows-Finance]]

@@ Line 62: / Line 62: @@
    Compare the data from the two printouts and note any discrepancies.
-===AMEX Reconciliation Worksheet===
+==AMEX Reconciliation Worksheet==
 #Copy over the list of stores following the existing format along with its associated discount charges. This will total up to the discount charges for the month. Leave a note to Nancy to move this sum to G/L 220154
 [[Category:Workflows-Finance]]

← Older revision		Revision as of 19:57, 9 November 2017
Line 61:		Line 61:

	Compare the data from the two printouts and note any discrepancies.		Compare the data from the two printouts and note any discrepancies.
		+
		+	===AMEX Reconciliation Worksheet===
		+	#Copy over the list of stores following the existing format along with its associated discount charges. This will total up to the discount charges for the month. Leave a note to Nancy to move this sum to G/L 220154
		+	#

	[[Category:Workflows-Finance]]		[[Category:Workflows-Finance]]

@@ Line 60: / Line 60: @@
 #Use the data from the printout for the Reconciliation
-   Compare the data from the two printouts to look for any discrepancies.
+   Compare the data from the two printouts and note any discrepancies.
 [[Category:Workflows-Finance]]

@@ Line 54: / Line 54: @@
 #Print out the AMEX Bank statement from the ''''CIBC Bank Statements''' folder
 #Use the data from the printout for the Reconciliation
 #Locate the file '''Visa & MC Transfers Feb17-Jan18'''{{unc|\\SUPERSERVER\Accounting\common\Bank Reconciliations\Visa-MC Transfers\Visa & MC Transfers}} and print out the corresponding month

← Older revision		Revision as of 19:51, 9 November 2017
Line 50:		Line 50:

	[[File:GL Printing 100100.JPG\|400px]]		[[File:GL Printing 100100.JPG\|400px]]
		+
		+	==CIBC AMEX Bank Statement & Visa/MC Transfers==
		+	#Print out the AMEX Bank statement from the ''''CIBC Bank Statements''' folder
		+	#Use the data from the printout for the Reconciliation
		+
		+	#Locate the file '''Visa & MC Transfers Feb17-Jan18''' from {{unc\|\\SUPERSERVER\Accounting\common\Bank Reconciliations\Visa-MC Transfers\Visa & MC Transfers}}

	[[Category:Workflows-Finance]]		[[Category:Workflows-Finance]]

@@ Line 47: / Line 47: @@
 # Click '''Print General Ledger''', hit enter
 # Put the correct period and GL number you wish to print and change the printer queue to '''LP05''' (see screenshot below)
 [[File:GL Printing 100100.JPG|400px]]