QBO bank reconciliation (disclaimer: fictional accounts)
RV SHOP
America's First Bank, Period Ending 01/31/2022
RECONCILIATION REPORT
Reconciled on: 07/15/2022
Reconciled by: Rona Erica Chavez
Any changes made to transactions after this date aren't included in this report.
Summary
PHP
Statement beginning balance
Checks and payments cleared (32)
Deposits and other credits cleared (4)
Statement ending balance
3,096.04
-41,-,-,682.70
Uncleared transactions as of 01/31/2022
Register balance as of 01/31/2022
Cleared transactions after 01/31/2022
Uncleared transactions after 01/31/2022
Register balance as of 07/15/2022
-14,541.08
-2,-,-
Details
Checks and payments cleared (32)
DATE
TYPE
REF NO.
PAYEE
01/03/2022
01/03/2022
01/04/2022
Check
Expense
Expense
2
Clint Phillips
Slack
PLDT
01/05/2022
01/10/2022
01/10/2022
01/11/2022
Expense
Expense
Expense
Expense
01/12/2022
01/12/2022
01/12/2022
01/14/2022
Check
Bill Payment
Expense
Expense
01/14/2022
01/14/2022
01/14/2022
01/18/2022
America's First Bank
Hilton Hotels
Mercury Drug
1
AMOUNT (PHP)
-1,000.00
-300.00
-447.22
-45.65
-500.00
-532.00
-139.99
Charles Zitting
Dale Butler
PAYPAL
Carlos Gianfelice
-295.00
-1,000.00
-19.59
-300.00
Expense
Expense
Expense
Credit Card Payment
Citi Costco
Bruce Nelson
Burger King
Citi Costco
-4,000.00
-8,473.46
-100.00
-555.00
01/18/2022
01/18/2022
01/18/2022
01/19/2022
01/21/2022
Expense
Expense
Expense
Expense
Bill Payment
Hubstaff
Enviroclean USA LLC
Cathy Ellason
Atlassian Pty
Brian Miller
01/21/2022
01/24/2022
01/24/2022
01/24/2022
01/26/2022
01/26/2022
01/27/2022
01/28/2022
Credit Card Payment
Expense
Expense
Check
Expense
Expense
Bill Payment
Expense
Citi Costco
Enviroclean USA LLC
Enviroclean USA LLC
Clark Kimball
SeedX Inc. Innovative Tech
MLH Consular Consulting
Dave Morley
America's First Bank
-143.00
-455.55
-725.00
-219.89
-1,000.00
-376.00
-2,500.00
-100.00
01/31/2022
01/31/2022
01/31/2022
01/31/2022
Expense
Expense
Expense
Expense
MLH Consular Consulting
Smart Globe Internet
LexisNexis
LexisNexis
-257.84
-1,005.00
-689.20
-391.80
6
Total
-240.00
-65.00
-222.15
-100.00
-15,000.00
-41,198.34
Deposits and other credits cleared (4)
DATE
TYPE
REF NO.
01/07/2022
Receive Payment
Andy Thomas
14,250.00
01/11/2022
01/13/2022
01/15/2022
Receive Payment
Deposit
Sales Receipt
Anine Mahoney
OWNER's ACCOUNT
Amanda Nopens
17,-,000.00
5,035.00
1004
PAYEE
Total
AMOUNT (PHP)
49,785.00
Additional Information
Uncleared checks and payments as of 01/31/2022
DATE
TYPE
REF NO.
PAYEE
01/31/2022
01/31/2022
Bill Payment
Bill Payment
3
4
Aaron Simpson
Brandon Williams
Total
AMOUNT (PHP)
-7,994.32
-6,546.76
-14,541.08
Uncleared checks and payments after 01/31/2022
DATE
TYPE
REF NO.
PAYEE
AMOUNT (PHP)
DATE
TYPE
REF NO.
PAYEE
02/05/2022
Refund
1005
Andy Thomas
Total
AMOUNT (PHP)
-1,500.00
-1,500.00
Uncleared deposits and other credits after 01/31/2022
DATE
TYPE
02/03/2022
02/05/2022
Receive Payment
Receive Payment
Total
REF NO.
PAYEE
Katharina Salmen
Sandra Grube
AMOUNT (PHP)
587.22
4,118.61
4,705.83