Automated Akaunting Receivables Aging
Every Monday, WebRun opens Akaunting, reads every unpaid customer invoice with its due date and outstanding balance, buckets them into current, 30, 60, and 90 days late, saves the aged receivables sheet into Google Drive, and sends you the biggest and oldest balances on WhatsApp.
How do I get an aged receivables report out of Akaunting every week?
Every Monday WebRun opens Akaunting, reads every unpaid customer invoice with its due date and balance, buckets them by how many days late they are, saves the aged receivables sheet into Google Drive, and sends you the biggest and oldest balances on WhatsApp, so chasing starts with the right names.
- The oldest and largest balances get chased first
- A dated receivables sheet lands in Drive every Monday
- Part payments are netted off so balances are honest
Built for small business owners · bookkeepers · freelancers · accounting practices
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
app.akaunting.comin a real browser with your saved login - no setup, no API keys. -
1
Akaunting - read every unpaid invoice
akaunting.com
WebRun opens Akaunting to read every unpaid invoice. - Open Akaunting and list customer invoices that are not fully paid
- Capture the customer, invoice number, invoice date, due date, and amount outstanding
- Subtract any part payments so the balance shown is what is actually still owed
- Bucket each invoice as current, 1 to 30, 31 to 60, 61 to 90, or over 90 days late
Done when Every open invoice has an outstanding balance and an aging bucket.
-
2
Google Drive - file the aged receivables sheet
drive.google.com
WebRun opens Google Drive to file the aged receivables sheet. - Save this week's aged receivables sheet into your finance folder in Google Drive
- Give it one row per invoice and a totals row per aging bucket
- Name the file with the run date so weekly files sort in order
- Leave last week's file in place so you can compare the two
Done when A dated aged receivables sheet sits in the Google Drive finance folder.
-
3
WhatsApp - send you the top balances
whatsapp.com
WebRun opens WhatsApp to send you the top balances. - Send yourself a WhatsApp summary with the total owed and the total over 60 days
- Name the five largest balances and how many days late each one is
- Say what moved since last week, including anything that got paid
- Link the Google Drive sheet for the full detail
Done when You know this week's total owed and which customers to chase first.
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
Will it email my customers about their overdue invoices?
No. WebRun produces the aged sheet and the WhatsApp summary only. If you want chasers sent, it drafts them and leaves them for you to review and send.
Does it change anything in my books?
No. WebRun reads invoices and payments in Akaunting and writes nothing back, so balances, statuses, and reconciliations stay exactly as your bookkeeper left them.
How does it handle part payments?
It subtracts payments already applied to each invoice and ages the remaining balance, so a partly paid invoice shows what is still owed rather than the original total.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.