Xero - GST Reconciliation
GST Reconciliation
Company ABC
From 1 July 2020 to 30 June 2021
Cash Basis
GST Collected
GST Period
Opening Balance
1 Jul 20 - 30 Sep 20
GST Collected
7,199
Unfiled
7,199
1 Oct 20 - 31 Dec 20
-
7,199
1 Jan 21 - 31 Mar 21
-
7,199
1 Apr 21 - 30 Jun 21
642
Total
Adjustments
Filed
7,841
7,841
-
-
7,841
Adjustments
Filed
Unfiled
GST Paid
GST Period
GST Paid
GST On
Imports
650
-
650
1 Oct 20 - 31 Dec 20
-
-
650
1 Jan 21 - 31 Mar 21
-
-
650
1 Apr 21 - 30 Jun 21
478
-
1,128
1,128
-
Opening Balance
1 Jul 20 - 30 Sep 20
Total
-
-
1,128
GST Account Transactions
Date
Total
Transaction
Amount
-
GST Owing
Opening Balance
-
Plus GST Collected and Filed
-
Less GST Paid and Filed
-
Less Payments Made
Closing Balance
-
GST Account Summary
GST Owing
GST in Accounts Receivable
GST in Accounts Payable
GST in Expense Claims
Unfiled GST
21,731
(20,079)
6,713
Balance at 30 June 2021
8,366
GST Account Balance
8,366
GST Reconciliation | Company ABC | 26 June 2021
Page 1 of 1