📋
Configure Module
How to get the URL
1
Open your Google Sheet
2
Click
File → Share → Publish to web
3
Choose the sheet tab →
CSV
→ Publish
4
Copy the URL and paste below
Module Name
Published Google Sheets CSV URL
Connect & Load
Cancel
Fetching data…
Connecting to Google Sheets
📋
Unprocessed AP Dashboard
Refresh
As of
—
Overview
💰
Total Outstanding (PHP)
—
📄
Total RR Count
—
Open Receiving Reports
📅
Average Age (Days)
—
⚠️
Overdue Amount (PHP)
—
Aging Buckets
— Click to filter
All
—
—
Current
—
—
1–30 Days
—
—
31–60 Days
—
—
61–90 Days
—
—
91–120 Days
—
—
120+ Days
—
—
Aging Distribution
Outstanding PHP by bucket
Item Type Mix
Product vs. Cost breakdown
Currency Exposure
PHP-equivalent by currency
Top 25 Suppliers
Click a row to filter the detail table
By Amount
By RR Count
User Bottleneck
By total amount processed
Receipt Volume Trend
Daily RR count and amount
Transaction Detail
🔧 Filter & Search
✕
Search
Item Type
All Item Types
Product
Cost
Currency
All Currencies
PHP
USD
YEN
EUR
Due Status
All Due Status
Past Due
Due ≤7 Days
Not Yet Due
—
✕ Reset
Done
By RR
Line Items
Export CSV
Filters
Summary by Receiving Report
RR Number
↕
Supplier
↕
# Items
↕
Cur
↕
Amount (PHP)
↕
Receipt Date
↕
Due Date
↕
Age (d)
↕
Due Status
↕
Type
↕
User
↕
—
10 / page
25 / page
50 / page
100 / page
Line Items — Un-vouchered
RR Number
↕
Supplier
↕
PO Number
↕
Item Description
↕
Qty
↕
Cur
↕
Amount (PHP)
↕
Receipt Date
↕
Due Date
↕
Age (d)
↕
Due Status
↕
Type
↕
User
↕
—
10 / page
25 / page
50 / page
100 / page