Credit Card Receipts - Monthly R
Month Ending:
COMPANY ACCOUNTING LEDGER
Visa/MC/DC/Other
Total Receipts Per Web Payment Software (WPS)
Settlement Reports $ -
Less: Total Reversals Per WPS Reports $ -
Less: Total Credit Card Fees/Discounts Per Merchant
Account Statement
Less: Last Day of Month Settlements $ -
Net Credit Card Receipts $ -
Daily Credit Card Activity Per WPS Settlement Reports
Total Settled Total Reversed/Credited Back
DAY Visa/MC/DC/Other AMEX Visa/MC/DC/Other
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Totals $ - $ - $ -
Receipts - Monthly Reconciliation
R MERCHANT ACCOUNT STATEMENTS
AMEX
Total Transactions/ Amounts Submitted Per
$ - Statement
$ - Less: Chargebacks/ Reversals/ Refunds
Less: Fees/Discounts
Plus/Minus: Adjustments
$ - Net Amount Funded to Bank
$ -
Reversed/Credited Back BANK STATEMENT
AMEX
Deposits/Credits
Withdrawals/Debits
Net Credit Card Receipts
RECORDS COMPARISON
COMPANY ACCOUNTING LEDGER NET CC
RECEIPTS
MERCHANT ACCOUNT STATEMENT NET
PAYMENTS
DIFFERENCE #1
BANK STATEMENT NET CC RECEIPTS
DIFFERENCE #2
DIFFERENCE #1
Plus/Minus Prior Month Difference #1
NON TIMING-ISSUE DIFFERENCE
DIFFERENCE #2
Plus: Current Mo. Fees/Discounts
Minus: Prior Mo. Fees/Discounts
Minus: Settled amounts not yet deposited to bank
NON TIMING-ISSUE DIFFERENCE
$ -
ACCOUNT STATEMENTS
Cayan/First
Data/Vantiv/Other AMEX
FEES/DISCOUNTS ARE DEBITED THE MONTH FOLLOWING
Adjustments should include timing difference amounts (i.e
transactions settled on last day of month but not deposited to
bank until the following month)
$ - $ -
K STATEMENT
Cayan/First
Data/Vantiv/Other AMEX
$ - $ -
DS COMPARISON
Visa/MC/DC/Other AMEX
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ -
$ - $ - Investigate & resolve
$ - $ -
$ - $ -
$ - $ - Investigate & resolve
TH FOLLOWING
nce amounts (i.e
but not deposited to
Credit Card Receipts - Monthly R
Month Ending:
COMPANY ACCOUNTING LEDGER
Visa/MC/DC/Other
Total Receipts Per Web Payment Software (WPS)
Settlement Reports $ 2,663.08
Less: Total Reversals Per WPS Reports $ -
Less: Total Credit Card Fees/Discounts Per Merchant
Account Statement $ (400.26)
Less: Last Day of Month Settlements $ -
Net Credit Card Receipts $ 2,262.82
Daily Credit Card Activity Per WPS Settlement Reports
Total Settled Total Reversed/Credited Back
DAY Visa/MC/DC/Other AMEX Visa/MC/DC/Other
01
02 $ 839.65 $ 2,112.46
03
04
05
06 $ 359.95 $ 99.95
07
08
09
10
11
12
13
14
15 $ 819.63 $ 89.90
16
17
18 $ 268.65
19 $ 125.00
20 $ 16.43
21 $ 1,204.00
22
23
24
25 $ 99.95
26
27 $ 103.82
28 $ 30.00
29
30
31
Monthly Totals $ 2,663.08 $ 3,506.31 $ -
Receipts - Monthly Reconciliation
9/30/2017
MERCHANT ACCOUNT STATEMENTS
AMEX
Total Transactions/ Amounts Submitted Per
$ 3,506.31 Statement
$ - Less: Chargebacks/ Reversals/ Refunds
Less: Fees/Discounts
$ (189.89) Plus/Minus: Adjustments
$ - Net Amount Funded to Bank
$ 3,316.42
Reversed/Credited Back BANK STATEMENT
AMEX
Deposits/Credits
Withdrawals/Debits
Net Credit Card Receipts
RECORDS COMPARISON
COMPANY ACCOUNTING LEDGER NET CC
RECEIPTS
MERCHANT ACCOUNT STATEMENT NET
PAYMENTS
DIFFERENCE #1
BANK STATEMENT NET CC RECEIPTS
DIFFERENCE #2
DIFFERENCE #1
Plus/Minus Prior Month Difference #1
NON TIMING-ISSUE DIFFERENCE
DIFFERENCE #2
Plus: Current Mo. Fees/Discounts
Minus: Prior Mo. Fees/Discounts
Minus: Settled amounts not yet deposited to bank
NON TIMING-ISSUE DIFFERENCE
$ -
ACCOUNT STATEMENTS
Cayan/First
Data/Vantiv/Other AMEX
$ 4,623.73 $ 4,631.31
$ - $ -
$ (400.26) $ (189.89)
$ -
$ 4,223.47 $ 4,441.42
NK STATEMENT
Cayan/First
Data/Vantiv/Other AMEX
$ 4,593.73 $ 4,631.31
$ (213.10) $ (250.61)
$ 4,380.63 $ 4,380.70
DS COMPARISON
Visa/MC/DC/Other AMEX
$ 2,262.82 $ 3,316.42
$ 4,223.47 $ 4,441.42
$ (1,960.65) $ (1,125.00)
$ 4,380.63 $ 4,380.70
$ (157.16) $ 60.72
$ (1,960.65) $ (1,125.00)
$ 1,960.65 $ 1,125.00
$ - $ - Investigate & resolve
$ (157.16) $ 60.72
$ 400.26 $ 189.89
$ (213.10) $ (250.61)
$ (30.00) $ -
$ 0.00 $ 0.00 Investigate & resolve