Community Q&A

Ask your question (name + email + short query + explained question). Discover Talent provides official answers — visitors can react.

Ask a question
All fields required
We respect privacy — emails are not public.
June 28, 2026 19:39 • asked by Inayat Ullah
Debtor Aging
I have the client whom we have sold goods from Jan till June.


The sales have been on credit and we have also received cash from the client from Jan to June on different dates.

The credit period given him is 90 days.

the issue is that we have received cash receipt also

how can we make an aging report
Answer by Discover Talent ✔ Verified
Cash receipts should be allocated against the oldest outstanding invoices first (FIFO). This lets you calculate the actual unpaid balance and aging correctly.

If you give me the Excel data structure, I can provide the exact Excel formula/Power Query approach for this.
Was this solution helpful?
1 comments
Discover Talent ™ • September 21, 2026 19:16
Yes, an aging report can be created even when there are multiple credit sales and cash receipts.

The key is to maintain a transaction-level ledger:

Customer
Invoice Date
Invoice No.
Invoice Amount
Receipt Date
Receipt Amount
Outstanding Amount
Due Date = Invoice Date + 90 days
Aging Days = Today − Due Date
Aging Bucket: Not Due / 0–30 / 31–60 / 61–90 / 90+ days

Cash receipts should be allocated against the oldest outstanding invoices first (FIFO). This lets you calculate the actual unpaid balance and aging correctly.

If you give me the Excel data structure, I can provide the exact Excel formula/Power Query approach for this.
Be constructive — public content.
Add / Edit Solution (site team)
December 6, 2025 10:20 • asked by Vipul sharma
What is the file extension
What is the file extension for a standard, macro-free Excel workbook created in versions 2007 and later?
Answer by Discover Talent ✔ Verified
.xlsx (Standard Workbook): The default extension for Excel files created since version 2007. The 'x' stands for XML (referring to the underlying file structure) and, importantly, indicates the file does not contain any Visual Basic for Applications (VBA) code or macros. This is generally the safest file format.
Was this solution helpful?
0 comments
Be constructive — public content.
Add / Edit Solution (site team)
December 6, 2025 09:20 • asked by
How to use Vlookup
canyou help me how to use excel vlookup function?
Answer by Discover Talent ✔ Verified
If you have a table in cells A2:C10 (A=ID, B=Name, C=Department) and you want to find the Department for the ID in cell E2:$$\text{=VLOOKUP(E2, A2:C10, 3, FALSE)} Translation: "Look for the value in E2 within the first column of A2:C10, and bring back the value from the 3rd column (Department), requiring an exact match."
Was this solution helpful?
0 comments
Be constructive — public content.
Add / Edit Solution (site team)