Automated Amazon Order Invoice Collection
Every Monday, WebRun opens Amazon, works through last week's delivered orders, captures each order's invoice number, total, tax, seller, and payment method with a link to the invoice, files one row per order in Airtable, and sends the bookkeeper a Telegram summary of what is now ready to reconcile.
Amazon
collect last week's order invoices
How do I collect my Amazon order invoices for bookkeeping?
WebRun works through last week's delivered Amazon orders every Monday and captures each invoice: order number, date, seller, total, tax, payment method, and a link to the document. It files one row per order in Airtable without duplicates and sends the bookkeeper a Telegram summary of what is ready to reconcile.
- Card statements reconcile without digging through order history
- Every delivered order has its invoice link on record
- Orders with unreadable invoices are named instead of quietly missed
Built for bookkeepers · small business owners · office managers · ecommerce sellers · finance teams
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
amazon.comin a real browser with your saved login - no setup, no API keys. -
1
Amazon - collect last week's order invoices
WebRun opens Amazon to collect last week's order invoices. - Open Amazon order history and set the range to the previous week
- Skip anything not yet delivered so only settled orders reach the books
- For each order, capture the order number, date, seller, item summary, and order total
- Record the tax shown on the invoice and the payment method the order was charged to
- Keep the link to each order's invoice so the document is one click away from the record
- Read only. WebRun never places, cancels, returns, or repeats an order
Done when Every delivered order from last week has its invoice details captured.
-
2
Telegram - tell the bookkeeper what is ready
telegram.org
WebRun opens Telegram to tell the bookkeeper what is ready. - Send the bookkeeper the week's order count and total spend
- Name any order whose invoice could not be read, and say why
- List the payment methods used so a card statement can be matched line by line
Done when The bookkeeper knows what landed and what still needs a look.
-
3
Airtable - file one row per invoice
airtable.com
WebRun opens Airtable to file one row per invoice. - Add one row per order to your purchases table in Airtable
- Fill the order number, date, seller, total, tax, payment method, and the invoice link
- Skip orders already recorded so a repeated run never duplicates a purchase
- Leave the reconciled field empty for your bookkeeper to tick as the statement is matched
Done when Every order from last week is in Airtable exactly once, ready to reconcile.
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.
Amazon
Sign in once
Every action is checked against this policy before it runs.
Questions, answered
Can it buy anything or change an order?
No. WebRun reads order history only. It never places an order, repeats a purchase, starts a return, cancels anything, or opens saved payment details. Nothing it does costs money.
What about orders that have not arrived yet?
They are skipped until delivered, so only settled purchases reach the books. An order that arrives later is picked up on the run after it is marked delivered.
Will running it again duplicate rows?
No. Each order number is checked against Airtable before a row is added, so a re-run fills gaps rather than repeating last week.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.