Account Reconciliation via API

Account Reconciliation via API

I am suggesting that the Zoho Books team considers making it possible to do an Account Reconciliation via API.

The use case I have in mind is specific, but also fairly common: merchant services clearing accounts.

Currently, the only way to reconcile an account is manually. For users who have dozens or hundreds of transactions a day, this can get to be very tedious and time consuming. This scenario would be common for ecommerce or any business that does a fairly high number of credit card transactions per day that are captured as individual invoices/payments in Books.

Typically, when a merchant services provider (Braintree, Stripe, etc.) sends a periodic payout, one can access the individual transaction IDs associated with that payout. Braintree, for example, sends this information as part of the payout notification webhook.

If one has the data from the merchant about the payout amount and the individual transactions comprising the payout, it ought to be possible to do an automated reconciliation with some not-terribly-complex scripting if the capability for doing reconciliations was opened up in the Zoho Books API.

If the team is going to consider this, I would also propose that it be made possible to do the equivalent of "Save and Reconcile Later" programmatically. The use case here would be for the cases that require manual intervention (missing transaction, amount discrepancy, etc.). This would allow any automation to "check the box" for transactions that are correct, leaving only the ones that require manual attention for the user.

I hope there's value here. Let me know if there are additional details that would be helpful.
      Zoho Marketing Automation

            Zoho Pagesense Resources

              Zoho SalesIQ Resources

                    Zoho TeamInbox Resources

                      Zoho DataPrep Resources

                        Zoho CRM Plus Resources

                          Zoho Books Resources

                            Zoho Subscriptions Resources

                              Zoho Desk Resources

                                Zoho Projects Resources

                                  Zoho Sprints Resources

                                    Qntrl Resources

                                      Zoho Creator Resources

                                        Zoho WorkDrive Resources

                                            Zoho Campaigns Resources

                                              Zoho CRM Resources

                                                    Design. Discuss. Deliver.

                                                    Create visually engaging stories with Zoho Show.

                                                    Get Started Now