Difference between revisions of "Accounting Finance:GST"
Jump to navigation
Jump to search
m (→GST Worksheet) |
|||
| Line 2: | Line 2: | ||
== GST Worksheet == |
== GST Worksheet == |
||
| − | *Navigate to the GST folder and create a copy of the GST worksheet. Paste in the corresponding year's folder. Rename original worksheet to month GST is being prepared for. |
+ | *Navigate to the GST folder and '''create a copy of the GST worksheet'''. Paste in the corresponding year's folder. Rename original worksheet to month GST is being prepared for. |
| − | *Enter values for GL 122500 and 122000 in correct columns for current month. Add GST received in column E |
+ | *Enter values for '''GL 122500 and 122000''' in correct columns for current month. Add '''GST received''' in column E |
*Enter GST deposits/payments made in the month in the correct column (column I/K) |
*Enter GST deposits/payments made in the month in the correct column (column I/K) |
||
| − | *Update and drag formulas in the bottom section of the worksheet to the current month's cells. Enter the year to date values for GL 122000 and 122500. Discrepancies may be due to late receipts/entries of GST received/paid. Check the next period to ensure. If so, enter timing differences into the adjustment cell. |
+ | *'''Update and drag formulas''' in the bottom section of the worksheet to the current month's cells. Enter the year to date values for GL 122000 and 122500. '''Discrepancies''' may be due to late receipts/entries of GST received/paid. Check the next period to ensure. If so, enter timing differences into the '''adjustment''' cell. |
| − | *Ensure totals for Current and Year to Date Sections match |
+ | *'''Ensure totals for Current and Year to Date Sections match''' |
== CRA Netfile == |
== CRA Netfile == |
||
Revision as of 12:50, 24 October 2019
GST remittances are made monthly before the end of the the following month. Check with Nancy, Finance Manager, before making GST remittance to ensure that the month has been closed and no more entries are able to be posted into the previous month.
GST Worksheet
- Navigate to the GST folder and create a copy of the GST worksheet. Paste in the corresponding year's folder. Rename original worksheet to month GST is being prepared for.
- Enter values for GL 122500 and 122000 in correct columns for current month. Add GST received in column E
- Enter GST deposits/payments made in the month in the correct column (column I/K)
- Update and drag formulas in the bottom section of the worksheet to the current month's cells. Enter the year to date values for GL 122000 and 122500. Discrepancies may be due to late receipts/entries of GST received/paid. Check the next period to ensure. If so, enter timing differences into the adjustment cell.
- Ensure totals for Current and Year to Date Sections match
CRA Netfile
- Once worksheet is complete and totals match, navigate to CRA Netfile Website
- Enter the business number and Access code (can find in top left corner of GST worksheet). Enter dates reporting for (previous month). Click 'Next'
- Enter sales figure in Line 101 (same on used in PST calculation)
- Enter current from GL 122500 in Line 105
- Enter current for GL 122000 in Line 108
- Verify total matches the total in the worksheet
- Submit
- Save a copy of the return in the GST folder