Payment Calendar
What this page is for
The Payment Calendar helps you track Purchase Order (PO) payments over time so you can answer, at a glance:
- What payments are coming up soon, and who they are for
- What is already overdue, and how big the overdue amount is
- What has been paid, and what your cash outflow looks like across days
A “payment” here means a scheduled cash outflow linked to a PO. Each payment has:
- Due date
- Amount
- Status: Scheduled, Paid, or Overdue
- Payment type: Order payment, Shipping payment, or Other
- Optional recipient (beneficiary): supplier, destination, or freight forwarder
Access to this page depends on your plan or permissions. If it is not enabled, the page may appear blurred or blocked.
Page layout
There are two tabs.
1) Calendar tab
A calendar view (Month, Week, or Year) with an optional right sidebar that shows:
- An Overdue list
- An Upcoming list
- Details for the payment you select
2) Chart tab
A reporting view built from the same payments list. It includes:
- Totals by status (Scheduled, Paid, Overdue)
- Daily stacked bars by status
- Cumulative lines (running totals)
- Breakdown by payment type
- Export to Excel
Calendar tab
Year and navigation
Payments are loaded one year at a time, based on the year you are currently viewing.
- Moving within the same year does not reload data.
- Crossing into a new year loads the next year’s payments.
You will typically see controls like Today, previous/next arrows, and a header that matches your view (Month, Week, or Year).
Month / Week / Year views
You can switch between:
- Month: standard month grid. Days show payment items, and you can open a list for a day.
- Week: 7-day view with payments listed by day.
- Year: compact view showing months and payment activity.
This changes only how you see the data. It does not change what is loaded for the year.
Search by Purchase Order
You can search to show only payments that match a Purchase Order name.
What this affects:
- Which payments appear on the calendar
- Which payments appear in the Overdue and Upcoming sidebar lists
What this does not affect:
- It does not change what is fetched from the server. It is a visual filter.
Selecting a payment
In Month and Week views:
- A day shows up to 3 payments directly.
- If there are more, you will see a “+N more” indicator.
When you click a payment, the page treats it as the “selected payment” and shows its details (usually in the sidebar, and sometimes also in a popover).
Payment details you can view
When a payment is selected, you typically see:
- Purchase Order link (opens the PO page)
- Status: Scheduled / Paid / Overdue
- Payment type (Order / Shipping / Other)
- Recipient (beneficiary), if set (supplier, destination, or freight forwarder)
- Due date
- Amount
- Payment name, if it was provided
- An “Add to Google Calendar” link
Editing and deleting may appear in the interface, but if those actions are not enabled in your version, they will not do anything.
Sidebar lists
These lists are calculated from the payments you already have loaded.
Overdue
A payment appears in Overdue only if it is explicitly marked Overdue.
That means: a payment does not automatically become overdue just because the date passed. It must already have the Overdue status.
Upcoming
Upcoming includes payments that are due today or later, as long as they are not marked Overdue.
Also:
- Without a search term, Upcoming may show only the first 10 entries.
- With search, it shows all matches.
Chart tab
The Chart tab uses the same payments for the year, but adds an extra control:
Date range (Chart-only)
You can pick a date range inside the year to focus the charts and totals.
This range affects:
- All chart numbers and charts
- Drilldowns (details dialogs)
- Export to Excel
It does not change what is downloaded from the server, only what is included in calculations.
Chart metrics (what the charts mean)
All chart numbers are calculated from the filtered payments list (after applying the Chart tab date range).
Totals by status
Shows total amounts for:
- Paid
- Scheduled
- Overdue
Also shows the count of included payments.
Daily outflow (stacked bars)
For each day, the chart stacks amounts by status (Paid, Scheduled, Overdue) to show:
- How much is happening on each day
- Which part of that day’s total is paid vs scheduled vs overdue
Cumulative flow (lines)
Shows running totals across time, such as:
- Cumulative Total
- Cumulative Paid
- Cumulative Overdue
This helps you see how outflow builds up over the selected period.
Payment type distribution (pie/donut)
Groups total amount by payment type (Order payment, Shipping payment, Other, etc.) to show where the money is going by category.
Moving average
A smoothing line based on daily totals helps show trend over time. (If you see trend/forecast elements, they may exist visually even if forecasting logic is limited in the current version.)
Drilldowns (click-to-explain details)
When you click a status card (Paid, Scheduled, Overdue), a dialog opens that can show:
- By Purchase Order: totals and counts per PO
- By Recipient (beneficiary): totals and counts per supplier/destination/forwarder
This is mainly for answering “what makes up this number?”
Export to Excel (Chart tab)
Export writes one row per payment included in the chart date range.
Common columns include:
- Date
- Status
- Amount
- Payment type
- Purchase Order name
- Beneficiary type and name
Known limitation in some versions: amounts may be formatted as USD in export even if your data is not strictly USD.
What changes the data vs what only changes the view
Changes what is loaded from the server
- Year (because payments are fetched year-by-year)
Only changes what you see or how it is calculated locally
- Calendar tab vs Chart tab
- Month/Week/Year view mode
- Sidebar open/close
- Search term
- Selected date and selected payment
- Chart tab date range (affects charts and export only)
Important behavior to know
Overdue depends on status, not just the date
If a payment’s due date is in the past but it is not marked Overdue, it will not appear in the Overdue list. This is intentional based on how the system treats status.
Charts are daily
Charts aggregate by day. There is no weekly or monthly rollup in the current chart logic.
Upcoming list may be shortened
Upcoming can be capped (for example, 10 items) unless you search.