You’re offline. This is a read only version of the page.
Announcements
60
Hello Community,
We are currently working on migrating a client from QuickBooks to Microsoft Dynamics 365 Business Central, and I’d like to share their requirements to get guidance or best practices from the community.
Client receives payments through three methods:
Checks (scanned and deposited)
ACH transfers
Credit card payments
Payments are sometimes short due to:
Bank fees (e.g., international wire deductions)
Customer discounts (early payment discounts)
Bad debt write-offs
Occasional freight adjustments
QuickBooks allows categorizing these short payments into specific expense accounts (Bank Fees, Customer Discounts, Bad Debt, Freight).
Client often makes bulk deposits combining multiple checks or payments from different divisions/customers so that the deposit matches the bank statement.
Prepayments (payments without invoices) are also common.
Manual adjustment is sometimes required when discount amounts differ slightly between customer remittance and system calculation.
Ability to process customer payments via checks, ACH, and credit cards.
Flexibility to categorize short payments into correct expense accounts (Bank Fees, Discounts, Bad Debt, Freight).
Support for bulk deposits to match bank statements when multiple customers/divisions are involved.
Ability to handle prepayments without invoices.
Manual adjustment capability for discounts when customer remittance differs from system calculation.
Avoidance of excessive manual journal entries – categorization should be integrated into payment entry.
Option to link related customers/divisions (e.g., parent-child relationship) for consolidated deposits.
What is the recommended setup in Business Central to handle these scenarios?
Are there standard features or best practices for categorizing short payments directly during payment entry?
How can bulk deposits across multiple customers/divisions be managed effectively?
Any guidance on linking related customers/divisions for consolidated deposits?
We would appreciate any insights, configuration tips, or references to documentation that can help us replicate and improve this QuickBooks functionality in Business Central.
Thank you in advance!
