Automated Reckon Weekly GST Sheet Export
Every week, WebRun totals GST collected and paid in Reckon, exports the figures to a Google Sheet, and logs the summary to Notion so BAS time is never a scramble.
How do I track weekly GST figures from Reckon for BAS time?
WebRun totals GST collected and paid in Reckon every Monday, exports the figures with a running quarter to date total to a Google Sheet, and logs the net position to a Notion summary. It flags when the quarterly total looks unusually high or low, so BAS lodgement time starts from a number you've already been tracking, not a surprise.
- BAS prep starts from a running total instead of a fresh calculation
- The net GST position is visible every Monday
- Unusually high or low quarters get flagged early
Built for Australian small businesses · bookkeepers · accountants · sole traders
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.reckon.comin a real browser with your saved login - no setup, no API keys. -
1
Reckon - total this week's GST collected and paid
reckon.com
WebRun opens Reckon to total this week's GST collected and paid. - Open Reckon and pull last week's sales and purchase transactions
- Total the GST collected on sales and GST paid on purchases
- Note the net GST position for the week
Done when Last week's GST collected, paid, and net position are totaled.
-
2
Google Sheets - export the figures to a sheet
google.com
WebRun opens Google Sheets to export the figures to a sheet. - Export the week's GST figures to the running BAS tracking sheet
- Include the date range, GST collected, GST paid, and net position
- Keep a running quarter to date total
Done when The sheet reflects this week's GST figures and the quarter to date total.
-
3
Notion - log the summary to Notion
notion.so
WebRun opens Notion to log the summary to Notion. - Update the finance summary page with the week's net GST position
- Note how it compares to the previous week
- Flag if the quarter to date total looks unusually high or low
Done when The Notion summary shows this week's GST position.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it lodge my BAS for me?
No. It only totals and exports the GST figures already in Reckon. Lodging your BAS is still done by you or your accountant.
How is the net GST position calculated?
GST collected on sales minus GST paid on purchases for that week, read straight from Reckon's transaction records.
Does the sheet reset each quarter?
The running total tracks quarter to date and is ready to reset at the start of each new quarter, so BAS prep always starts from a clean total.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.