A receivables report answers a dated question. An invoice that is paid now may still have been open at last month's cutoff. Read the invoice date, payment dates and credit allocations separately before deciding which effects belong in the requested balance.
A payment may precede its invoice. At an earlier cutoff, that payment can reduce receivables before the later invoice enters the population, producing a negative historical effect. Don't discard it just because the invoice isn't yet visible at that date. These tasks use supplied fictional records in the US organization and a disclosed accrual subset. State the cutoff and distinguish gross invoice value, current amount due and historical amount due. None of those figures alone proves which customer should be contacted or that a later receipt had already arrived.