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 Desk Resources

                            • Desk Community Learning Series


                            • Digest


                            • Functions


                            • Meetups


                            • Kbase


                            • Resources


                            • Glossary


                            • Desk Marketplace


                            • MVP Corner


                            • Word of the Day



                                Zoho Marketing Automation


                                        Manage your brands on social media



                                                Zoho TeamInbox Resources

                                                  Zoho DataPrep Resources



                                                    Zoho CRM Plus Resources

                                                      Zoho Books Resources


                                                        Zoho Subscriptions Resources

                                                          Zoho Projects Resources


                                                            Zoho Sprints Resources


                                                              Qntrl Resources


                                                                Zoho Creator Resources


                                                                  Zoho WorkDrive Resources



                                                                    Zoho Campaigns Resources

                                                                      Zoho CRM Resources

                                                                      • CRM Community Learning Series

                                                                        CRM Community Learning Series


                                                                      • Tips

                                                                        Tips

                                                                      • Functions

                                                                        Functions

                                                                      • Meetups

                                                                        Meetups

                                                                      • Kbase

                                                                        Kbase

                                                                      • Resources

                                                                        Resources

                                                                      • Digest

                                                                        Digest

                                                                      • CRM Marketplace

                                                                        CRM Marketplace

                                                                      • MVP Corner

                                                                        MVP Corner




                                                                            Design. Discuss. Deliver.

                                                                            Create visually engaging stories with Zoho Show.

                                                                            Get Started Now