How to Automate CONTPAQi

The business arrives split across Contabilidad, Bancos and Comercial

CONTPAQi is Mexican administrative and accounting software, and it is not one program but a suite that most firms run several pieces of at once. CONTPAQi Contabilidad keeps the books. CONTPAQi Bancos runs the money in and out. CONTPAQi Comercial, in its Start, Pro and Premium editions, handles sales, stock and invoicing, and CONTPAQi Nominas runs payroll.

The people on it are accountants above all: a despacho carrying thirty client companies, and the internal accountant of a mid-sized firm who is the only person who knows where everything is posted.

What sits inside is the fiscal life of the company. Every CFDI issued and received, the polizas behind them, balances by customer and by supplier, bank accounts in more than one currency, stock, payroll, and the declarations built out of all of it.

It runs on a machine in the office or on a hosted desktop, and in either case it is the record the accountant defends when somebody asks.

The month closes on the SAT portal, not in the software

The posting is the part that is under control. Everything around it is a browser.

Somebody signs into the SAT to download the CFDIs the company received, because a supplier's invoice does not arrive in CONTPAQi by itself, and an expense with no document behind it is an expense that is not deductible.

Somebody checks the buzon tributario, because that is where the tax authority talks to you and it does not send a reminder.

Somebody opens each bank to pull the statement, then works out which movement belongs to which invoice and which supplier is still owed.

Somebody chases the suppliers who have not stamped an invoice yet, and the customers who have not paid one. Somebody confirms a counterparty is still in good standing before a payment leaves.

It is a week of the month, done in browser tabs, by the person least able to spare it.

CONTPAQi

Supplier CFDIs chased in week one What the SAT shows as received against what has actually been posted, so a missing document is a request rather than a lost deduction.

The buzon read every morning Notifications from the tax authority surfaced the day they appear, with the deadline attached, instead of found at the end of the month.

Payments matched to the invoice they settle Bank movements set against the CFDI balances recorded in Bancos, so a credit applied to the wrong account is found while it is fresh.

The ADD validates every CFDI the company already has

CONTPAQi automates a great deal of this, and a firm using only half the suite is doing work the licence already covers.

Contabilidad validates and classifies documents in the ADD, verifying them against the SAT, and generates the electronic accounting files for Anexo 24. It builds the DIOT as a bulk TXT ready to load, applies automatic accounting rules so a posting is generated from the XML rather than typed, handles IVA control and the files for a refund request, and converts across currencies. Bancos reconciles accounts automatically, downloads movements from Banamex, BBVA, Banorte, Banregio and Scotiabank, tracks CFDI balances against the entries they belong to, and lists what is scheduled to be paid. The parts of the suite share data, so a payroll run posted in Nominas is not typed a second time into Contabilidad.

That is genuinely strong, and it is worth exhausting before looking further.

Every one of those features starts from a document the suite already holds. Whether a supplier has stamped this month's invoice at all, what the buzon says today, what a distributor is charging now, and whether a payment cleared at a bank outside the supported list are facts on other people's websites.

The proof of a posting lives on a site the suite cannot open

Closing week can shrink to a morning check, because everything it waits on is published on a site with a login.

The SAT's record of what was issued and received compared with what has actually been posted in Contabilidad, so a missing supplier CFDI is chased in the first week of the month instead of the last.

The buzon tributario read on a schedule and reported, so a notification is a fact somebody knows about the day it appears.

Bank movements read from whichever bank the company actually uses and set against the CFDI balances in Bancos, so a payment applied to the wrong invoice is found while everyone still remembers it.

Suppliers who have not stamped, listed by how long it has been, with the request drafted and waiting to be sent. Customers past their terms, aged, with a statement prepared per account rather than assembled by hand.

And the buying side: this month's price on a supplier's portal measured against the last purchase posted in Contabilidad, so nobody places an order without seeing which costs moved.

The declaration still goes out in a person's name

None of that is judgement. It is a list of sites opened in order and read carefully, and the firm already holds every credential.

WebRun is an agent that works a real Chrome browser, signed in as you. It opens the SAT portal, a bank, a supplier's site or the buzon, reads what each one shows, sets it against what CONTPAQi recorded, and hands back one short list: what is missing, what does not agree and who has not stamped.

It runs on your schedule in your own private environment, and any run can be watched and stopped. Anything filed with the SAT, paid to a supplier or sent to a client is prepared and waits for you.

The workflows below are already built, and each one names what it opens.