Skip to content
All routines
FinanceDuring month-end

Month-end input tracker

Bring accounting records and the close checklist together, then flag missing inputs and owners.

Starting request

Tell OpenTag exactly what to repeat

“At 09:00 [timezone] on the last three weekdays of each month, compare our Xero records with the close checklist in Google Sheets. Post missing inputs and their owners in #finance.”

Use this as a starting point, then replace the example details with the sources, scope, and destination your team uses.

Shape it around your team

The example gives you a useful structure. The connections, scope, and schedule should match the way your team actually works.

  1. 1

    Connect the sources

    Connect Xero and Google Sheets. OpenTag can only use the accounts and records those connections allow.

  2. 2

    Make the scope explicit

    Name the exact accounts, projects, owners, date range, and time zone that matter. Replace the example details with your team’s own.

  3. 3

    Check the first run

    Run it once, review the source links and Slack destination, then keep or adjust the during month-end timing.

Keep the same team context and find another recurring job to hand off.

View all finance
  • FinanceEvery Monday

    Invoice aging report

    List overdue invoices and show which customers account for the largest outstanding balance.

    • Stripe· Read only
    • Slack
    Example request

    “Every Monday at 09:00 [timezone], list overdue Stripe invoices by age and show which customers account for the largest outstanding balance. Post the sourced report in #finance.”

    View routine
  • FinanceEvery Wednesday

    Stalled agreements report

    Find agreements still waiting on signatures and group them by owner and time outstanding.

    • DocuSign
    • Slack
    Example request

    “Every Wednesday at 10:00 [timezone], list DocuSign envelopes still waiting on signatures, grouped by owner and time outstanding. Post links in #operations.”

    View routine

Describe the job. OpenTag builds the routine.

Name what to read, the period to cover, the result you need, when it should run, and where it should go. Run it once and check the result before relying on the schedule.

  • Sources
  • Time window
  • Output
  • Schedule
  • Destination