Journal Logic, AR/AP Controls & Bank Deposit Reconciliation Mechanics
1. Overview
This document defines the financial transaction controls and operational accounting workflows governing journal entries, AR/AP handling, vendor and customer payments, deposit processing, and payout reconciliation within Xoro. It establishes structured posting discipline, outlines restrictions around receivables and payables, explains reconciliation mechanisms such as Undeposited Funds and Bank Deposit aggregation, and clarifies how Shopify and external payment processor payouts must be validated. The purpose of this document is to ensure financial traceability, clean ledger activity, controlled adjustments, and accurate reconciliation across ERP-integrated environments.
2. Functional Workflow
2.1 Journal Entry Module – Core Functionality
Purpose
Journal Entries are used for:
Fixing mistakes
Adjustments
Reversals
Core Controls
• Posting Date determines financial period impact • Currency selection controls exchange rate visibility • Exchange rate can be edited for foreign currency entries • Reference Number and Memo provide documentation context • “Show Transactions” displays debit/credit impact • Journal entries can be duplicated
Recurring Journal Entries
Recurring entries support:
Frequency
Start date
End date
Days in advance
Recurring entries can be:
Viewed
Edited
Manually rerun
Deleted
Control Rules
• Posting date determines period impact • Multi-currency entries must use the same currency across all lines • Always verify debit/credit impact using “Show Transactions” • Recurring entries are suitable for subscriptions and fixed recurring contracts
2.2 Tax Handling – Inclusive vs Exclusive
Tax Inclusive
• Entered amount includes tax • System splits base amount and tax
Tax Exclusive
• Tax is added on top of entered amount • Total payable increases
Control Rule
• Tax mode selection changes financial calculation behavior
2.3 AR/AP Rules & Restrictions in Journal Entries
Posting Requirements
• If posting to Accounts Receivable → Customer must be selected • If posting to Accounts Payable → Vendor must be selected
Additional Requirements
• Store association required
System Behavior
Debit or credit to AR/AP may create:
Invoice
Credit Memo
Bill
Vendor Credit
Deposits & Prepayments
• Customer Deposits and Vendor Prepayments do not appear in JE dropdown • Not recommended to post deposits via Journal Entry
Control Rules
• Avoid using Journal Entries for AR/AP unless unavoidable • Deposits and prepayments must link to Sales Orders or Purchase Orders • If adjustment is required, it must later be reversed • Journal Entries do not properly link deposits to specific transactions
2.4 Adjusting, Reversing & Home Currency Adjustments
Adjusting Entry
• Used to correct past or closed period issues
Reversing Entry
• Forward-looking • Automatically reverses on selected date
Home Currency Adjustment
• Used in multi-currency environments • Adjusts home currency value only • Foreign currency remains unchanged
Clarification
• Adjusting = historical correction • Reversing = temporary entry with auto-reversal • Home Currency Adjustment resolves exchange variance at fiscal year end
2.5 Funds Transfer Module
Purpose
• Transfer funds between accounts • Example: Bank A → Bank B
Use the Funds Transfer module instead of Journal Entry for account-to-account movements. This ensures a cleaner audit trail and clearer transaction traceability.
2.6 Account Register – GL Activity & Export Control
Function
• Represents full GL activity • Official source for account-level review
Filtering Options
• Date • GL account
Export Controls
• Export via Data Export Center • Always apply custom date filters before exporting
Control Rule
• Failure to apply date filter may export entire database
2.7 Bill Payment Process – Vendor Payments
Purpose
• Pay posted vendor bills
System Indicators
• Green light indicates available credits or prepayments
Payment Rules
• Credits can be applied • Early payment discounts may be auto-applied via payment terms or manually applied using an expense GL account.
Grouping Logic
• Same vendor bills → one payment number • Different vendors → separate payments
2.8 Check Printing & Print Queue
Process
• Pay via Check sends transaction to Print Queue • Checks are not printed immediately
Batch Print Workflow
• Assign sequence number • Confirm • Preview • Print • Mark as Printed
Control Rule
• Always mark checks as printed after physical printing
2.9 Invoice Payment Process – Customer Payments
Purpose
• Record customer payments against AR
Controls
• Credits and deposits visible • Discounts can be applied • Payment must match actual received amount • Apply to selected invoices
Deposit Destination
Payment may go to:
Bank account
Undeposited Funds
2.10 Write-Offs, Discounts & Partial Payments
Underpayment Handling
If customer underpays:
Leave partially paid
Write-off difference to expense GL
Common Use Case
• Shopify penny differences
Control Rule
• Use correct expense GL for write-offs • Avoid leaving small residual balances
2.11 Undeposited Funds Workflow
Purpose
• Clearing account for collected payments
Usage
• Multiple checks collected • Later combined into one deposit
Control Rule
• Undeposited Funds must be cleared through Bank Deposit
2.12 Bank Deposit Module & Combined Deposits
Function
• Combine multiple payments into one deposit • Print deposit slip
Control Rule
• Deposit totals must match bank statement • Critical for reconciliation accuracy
2.13 Shopify & Payment Processor Payout Handling
System Behavior
• Shopify payouts combine multiple transactions • Stripe, Authorize.net, Xoro Pay follow similar payout logic
Deposit Module Role
• Validate payout • Apply processor fees • Identify discrepancies
Control Rule
• Always validate payout details against Shopify inside Deposit module
3. Core Governance Principles
• Never use Journal Entry for customer deposits or vendor prepayments unless absolutely necessary • Multi-currency Journal Entries must use the same currency on all lines • Home Currency Adjustment changes only home currency value • Always filter by date before exporting Account Register • Vendor grouping determines payment number behavior • Underpayments must be written off or left partially paid intentionally • Undeposited Funds must be cleared through Bank Deposit • Shopify payouts must be validated inside Deposit module
4. Frequently Asked Questions (FAQs)
Q1. Can we post customer deposits via Journal Entry? A: No. Deposits must link to specific sales orders. Journal entries break traceability.
Q2. Why don’t customer deposit accounts appear in JE dropdown? A: Because deposits must associate to transactions, not standalone ledger entries.
Q3. What happens if I debit Accounts Payable in JE? A: System may create vendor credits or bills depending on direction.
Q4. What is the difference between adjusting and reversing entry? A: Adjusting fixes past period. Reversing auto-reverses in future period.
Q5. When should I use Undeposited Funds? A: When collecting multiple payments before making a combined bank deposit.
Q6. How do I handle penny differences from Shopify? A: Use batch discount or write-off to expense GL.
Q7. Why did system create two payment numbers for bill payment? A: Because bills belonged to two different vendors.
Q8. What does green light mean in Bill Payment? A: Vendor credit or prepayment available.
Q9. Can I print checks immediately? A: No. They go to Print Queue first.
Q10. What is Home Currency Adjustment used for? A: To correct exchange rate variance at fiscal year end.
Q11. A customer underpays an invoice by $0.12 from Shopify. What should you do? A: Use write-off or batch discount to expense GL.
Q12. You need to transfer funds between two bank accounts. Should you use Journal Entry? A: No. Use Funds Transfer module.
Q13. You posted a JE in CAD on first line and USD on second line. What happens? A: System requires same currency on all lines.
Q14. You need to fix a mistake in a closed period. What type of entry? A: Adjusting entry.
Q15. You want today’s entry to auto-reverse next month. What feature? A: Reversing entry with reversal date.
Q16. Why shouldn’t you use JE for vendor prepayments? A: It will not tie payment to specific PO and breaks tracking.
Q17. Multiple checks collected in a day — how do you deposit? A: Post to Undeposited Funds and use Bank Deposit to combine.
Q18. Where do you validate Shopify payout discrepancies? A: Bank Deposit module.
Q19. Vendor bill shows green indicator. What does that mean? A: Vendor credit or prepayment available.
Q20. You exported Account Register without date filter. What risk? A: Entire database may export instead of selected fiscal period.
5. Conclusion
Structured control over journal entries, AR/AP restrictions, payment processing, and deposit reconciliation ensures financial accuracy and audit integrity within Xoro. By enforcing disciplined posting behavior, correct payout validation, and clean deposit aggregation, organizations maintain reliable ledgers, accurate reconciliation, and controlled integration between ERP and external commerce platforms.
Last updated
Was this helpful?