Accounting Finance:TD Bank Merchant Statements - Revision history

Donnak: /* Print Merchant Statements */

2019-03-13T21:59:29Z

Print Merchant Statements

Donnak: /* Print Merchant Statements */

2019-03-13T21:58:50Z

Print Merchant Statements

Mikeg: /* Work with Manual Adjustments */

2017-11-15T20:04:30Z

Work with Manual Adjustments

Mikeg at 20:04, 15 November 2017

2017-11-15T20:04:00Z

Mikeg: Created page with "==Log on== Go to: [https://www.mistgateway.com:33808/tdreport/stmt https://www.mistgateway.com:33808/tdreport/stmt] Enter username (email address) *Enter password File:TD1..."

2017-10-12T22:09:50Z

Created page with "==Log on== *Go to: [https://www.mistgateway.com:33808/tdreport/stmt https://www.mistgateway.com:33808/tdreport/stmt] *Enter username (email address) *Enter password File:TD1..."

New page

==Log on==
*Go to: [https://www.mistgateway.com:33808/tdreport/stmt https://www.mistgateway.com:33808/tdreport/stmt]
*Enter username (email address)
*Enter password
[[File:TD1.png|400px]]

==Summary Reports==
*To download summary reports:
#Click '''Monthly Statement'''
#Click '''Summary''' from the drop down menu
#Click the month you are working on, click '''open''', print report, click '''X''' to close report, put aside
#On the left side click '''Monthly Statement''' to bring you back to statement type
#This time pick '''200-22378885 (UNIPHARM WHOLESALE DRUGS)'''
#Click the month you are working on, click '''open''', print report, click '''X''' to close report, put aside
[[File:TD2.png|400px]]
[[File:TD3.png|400px]]

*To download UWD summary report:
#On the left side click '''Reports'''
#Click '''Settled Transaction Details'''
#Double click the plus (+) sign on the uniPHARM Chain Account. A list of uniPHARM stores will appear.
#Choose the uniPHARM account '''200-022378885 (UNIPHARM WHOLESALE DRUGS)'''
#Click the double right arrow
#Change the start and end date
#Click '''CSV'''
#Click '''Submit'''
#Click '''open'''
[[File:TD4.png|400px]]

==Worksheets==
*Preparing a UWD worksheet:
#The file will open in Excel Format
#Go to \common\A2013-2014 (current)\Bank Discount Charges and click to open the Merchant Statement you are working on
#Click '''UWD tab'''
#Check to make sure the column headings on A-Q match the downloaded data
#Paste downloaded data onto columns A-Q and check row numbers.
#Change the column headings for B and C to store number and store owner.
#Populate both columns using the formulas below:
-Store Number: =IF(+F2="V",VLOOKUP(+E2,'V Table'!$A$5:$G$135,2,0),VLOOKUP(+E2,'M Table'!$A$5:$G$200,2,0))
-Store Owner: =IF(+F2="V",VLOOKUP(+E2,'V Table'!$A$5:$G$135,3,0),VLOOKUP(+E2,'M Table'!$A$5:$G$200,3,0))
[[File:TD5.png|400px]]

===Tips===
*If one of the fields show up as N/A note the credit card number, settlement date and go to Online Mart to check who the owner of the card is. Add the information on the V table (Visa) or M table (MC). Once the tables are updated the fields will populate.
*'''Note:''' If you do not have access to Online Mart you may also check the credit card details on Y:\uniPHARM-TD Batches\2013-2014 by finding the worksheet that matches your transaction date.
*Data sort the copied columns by Merchant ID and check all the gray columns against the uniPHARM statement #22378885 that you previously printed. Make sure all the totals match.
*Check and fix the reconciliation box if necessary.

==Invoicing Stores==
*Invoice the stores with fees greater than $1 and enter the invoice number on the worksheet beside Customer Billing.
*'''Note:''' Michael Fish (10567 and 11900) and Geoffrey Wong (10146 and 10334).
*See FIN-AR-005 to do the manual invoicing for the stores. Item number to be used is 02003812.
*Email or fax all the invoices to the respective stores.
[[File:TD6.png|400px]]

==Data Worksheets==
*Click on the Data tab and compare the column totals (E-CA) against the Summary statement that you previously printed.
*Update column CB by doing a vlookup on the Maxwell Paper spreadsheet on K:\common\AR\2013-2014 (current)\Bank Discount Charges.
*Check the TD statements of stores that have recently returned their terminals or had adjustments done to their account and compare it with the UWD statement we have for them, correct if necessary
*Do random checks by opening different store statements on [https://www.mistgateway.com:33808/tdreport/stmt https://www.mistgateway.com:33808/tdreport/stmt] and checking them against the UWD statements under the Portfolio tab worksheet.
*Under the Data tab check that the store charges total + UWD terminal charges total = total amount charged to your bank. Maxwell paper will be paid by UWD and will be on their UWD statement.
*Do internal adjustments to invoice the stores (no paper document) using the amounts on column CM (Store charges total).

==Work with Manual Adjustments==
*Select '''ASW FastPath→Cash Management→AR Cash Management Tasks→AR Invoicing Tasks→Enter Financial Transactions'''
[[File:TD7.png|400px]]

*Enter voucher type '''10'''
*Enter Batch amount
*Click '''User Template'''
*Change template to '''CVM'''
*Click '''enter'''
[[File:TD8.png|400px]]
[[File:TD9.png|400px]]

*Enter next customer OR
*Click '''F12''' when all adjustments are entered
#Enter Doc # (MMDDYY of TD charges)
#Enter Customer number
#Enter Transaction amount (total of both Visa & MC charges)
#Enter text (enter the month & year of the charges)
#Press '''enter''' twice
[[File:TD10.png|400px]]

*Enter Amount
*Click '''enter'''
[[File:TD11.png|400px]]
*Click '''F3''' to complete adjustment entry
*Click '''F3'''
*Mark '''close batch'''
*Change Printer queue '''lp05'''
*Click '''enter'''
[[File:TD12.png|400px]]
*Click '''enter'''
*Make sure there is no difference in total debit and credit
[[File:TD13.png|400px]]

==Print Merchant Statements==
*Check your printer set-up before printing statements.
*Click '''Print ALL statements''' (under the Portfolio tab).
*Slot all printed statements and mail the customer statements.
*Stores now have access to TD merchant online report to get a copy of the TD statement. When a store requests for a copy offer to set them up online.
[[File:TD14.png|400px]]

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

@@ Line 103: / Line 103: @@
 *Check your printer set-up before printing statements.
 *Click '''Print ALL statements''' (under the Portfolio tab).
-*Slot all printed statements and mail the customer statements.
+*Slot all printed statements and mail the customer statements with the exception of Macdonalds.
 **Email Macdonalds (10478, 10479, 12004) email to Emilo Dente (office@macdonaldsrx.com) and then discard copy.
 *Stores now have access to TD merchant online report to get a copy of the TD statement. When a store requests for a copy offer to set them up online.

@@ Line 68: / Line 68: @@
 ==Work with Manual Adjustments==
 *Select '''ASW FastPath→Cash Management→AR Cash Management Tasks→AR Invoicing Tasks→Enter Financial Transactions'''
-[[File:TD7.png|400px]]
+[[File:TD7.png|300px]]
 *Enter voucher type '''10'''

@@ Line 1: / Line 1: @@
 ==Log on==
-*Go to: [https://www.mistgateway.com:33808/tdreport/stmt https://www.mistgateway.com:33808/tdreport/stmt]
+*Go to: [https://www.mistgateway.com:33808/tdreport/stmt TD Merchant Services]
 *Enter username (email address)
 *Enter password

Accounting Finance:TD Bank Merchant Statements - Revision history

Donnak: /* Print Merchant Statements */

Donnak: /* Print Merchant Statements */

Mikeg: /* Work with Manual Adjustments */

Mikeg at 20:04, 15 November 2017

Mikeg: Created page with "==Log on== *Go to: [https://www.mistgateway.com:33808/tdreport/stmt https://www.mistgateway.com:33808/tdreport/stmt] *Enter username (email address) *Enter password File:TD1..."

Mikeg: Created page with "==Log on== Go to: [https://www.mistgateway.com:33808/tdreport/stmt https://www.mistgateway.com:33808/tdreport/stmt] Enter username (email address) *Enter password File:TD1..."