Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Bookkeeping & finance

Transaction sync vs payout summaries: choose the right accounting detail

Decide which payment details belong in the ledger and which can remain in supporting records, with controls for payout totals, month-end cutoff, and duplicate imports.

By Institution4 minute readPublished View sources
In this guide

Choose detail according to the work the ledger must do

Individual transaction sync is useful when the accounting system must manage customer balances, apply payments to specific invoices, or report at a level that cannot be maintained reliably elsewhere. Summary posting can fit a business whose detailed order records remain in a dependable source system and whose ledger needs approved totals by account, period, entity, and other material dimensions.

The choice concerns where detail is maintained, not whether evidence is necessary. A summary should remain traceable to its underlying transactions. Thousands of individual entries can still be incomplete or misclassified, while a smaller set of controlled summaries can be reviewable. Start with the accounting and reporting requirements, then choose the posting method.

A net deposit is only one part of the picture

Suppose a fictional seller has $200,000 of customer charges, $10,000 of refunds, and $5,000 of processor fees in a defined settlement population. Assume there are no taxes, reserves, currency changes, disputes, or other adjustments in this simplified example. The resulting payout is $185,000. Posting only that bank deposit would omit the separate components needed to explain it.

Both transaction posting and summary posting should preserve those components under the accountant's approved mapping. The word summary does not mean that every amount becomes net sales. Nor does a payment charge automatically establish when revenue should be recognized; deposits, subscriptions, and other arrangements may require separate treatment.

A net deposit is only one part of the picture
Illustrative componentAmountControl to preserve
Customer charges$200,000Source population and approved account mapping
Refunds($10,000)Connection to original orders and credits
Processor fees($5,000)Fee detail separate from the sales population
Payout$185,000Settlement reference and matching bank receipt

Identify the records that need individual treatment

If the ledger issues customer invoices and owns accounts receivable, demonstrate how the integration applies each payment to the correct open item. A daily revenue journal alone does not close those invoices. The proposed design may need individual payment application even if other activity, such as fees, is summarized.

Consider customer credits, deposits, projects, inventory, and tax reporting separately. A company may need order-level information in an operational subledger without needing every order duplicated in the general ledger. Identify the authoritative location and the report that provides each required answer. Avoid importing details simply because an integration can produce them.

Test one real management question, such as margin by product group or unpaid balances by customer. Ask the team to produce the answer and trace it back to supporting records. If the method requires a recurring spreadsheet reconstruction with unclear ownership, the proposed granularity has not solved the reporting need.

Choose the summary period with month-end cutoff in mind

Synder documents daily, payout, monthly, and custom aggregation options, with availability depending on the integration and accounting platform. Its payout mode waits for a finalized payout, while other modes follow different periods. It also describes splitting payout activity across months. These are meaningful differences when finance needs to close before a processor finishes its payout cycle.

A2X's Amazon-to-Xero documentation similarly explains how a settlement spanning two months is split into separate invoices, using a carried-forward balance to connect the periods. This is a specific workflow, not a reason to assume every connector handles cutoff automatically. Request the behavior for your sales channel and ledger.

Use a settlement that begins before month-end and ends afterward. Agree which dates determine the entries, which activity remains unsettled at close, and how the later bank receipt clears the balance. A payout date should not silently replace the approved accounting-period rule.

References: Synder Help: Daily, payout, monthly, and custom summaries; A2X Support: Amazon settlements and split months in Xero

Keep a transaction register behind each summary

Retain the source identifiers, covered dates, included transaction types, totals, mapping version, and resulting accounting entry references. A reviewer should be able to select a transaction and locate its summary, then select a summary and retrieve its full population. Include access and export arrangements for the period after a connector subscription ends.

Control the point where posting methods change. If individual transactions were already imported through a certain date, a new summary must not include the same population again. Record the last accepted source record or period, reconcile the boundary, and keep evidence of excluded records. Different date filters can otherwise create an unnoticed gap or overlap.

Recovery deserves the same care. Re-running an import should identify previously accepted records. A correction to a closed period should follow the accountant's review process, preserving the original evidence and the reason for the change. Replacing entries merely to obtain a clean sync status is an inadequate control.

Approve the method when the reports reconcile

Compare the source totals, integration register, ledger balances, and bank receipt for the same population. Then repeat the comparison with a refund, a partial payment, and a settlement crossing month-end. Resolve unexplained differences before enabling automatic posting.

Choose the least complicated design that preserves the needed customer, operational, and accounting records. A mixed approach may be appropriate, but each transaction type needs one defined posting route and one owner for exceptions. The decision is complete when finance can explain both the totals and the detail behind them.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.