Customer balance as on 31.12.23 to be taken considering the payments till that date only

Hello there, Nrgaja.

To ensure I understand your request correctly and provide the best support, are you looking to generate a customer balance report as of December 31, 2023, that includes only payments received up to that date?

If so, you can generate a customer balance report and customize it to reflect payments made up to December 31, 2023.

Here's how:

1. Log in to QuickBooks and go to Reports.
2. Type in and select the Customer Balance Detail report.
3. Under the Report period dropdown, select Custom dates.
4. Type in or pick 31/12/2023 in the As of box.
5. Click the Customise button and tick the Paid filter.   

Otherwise, if you've generated a Customer Balance report and it shows incorrect amounts up to that date, please ensure that all payments are dated correctly. I'd also suggest checking your individual customers' transaction lists to ensure payments are linked to their corresponding invoices.

Furthermore, if you noticed a specific discrepancy or you're referring to something else, please share it below. Any additional information would help in providing you with an accurate solution.

Please leave a reply below if you have more questions about the QuickBooks reporting feature.