bank-payment-reconciliation

Reconciles daily bank feeds and payment gateway settlements against QuickBooks general ledger records.

1|Updated Jun 21, 2026
One-click install
npx skills add https://github.com/tapway/shogun-os --skill bank-payment-reconciliation-tapway
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: bank-payment-reconciliation
Source: https://github.com/tapway/shogun-os/tree/main/skills/finance/bank-payment-reconciliation
Command: npx skills add https://github.com/tapway/shogun-os --skill bank-payment-reconciliation-tapway

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Daily settlement files from payment gateways like Stripe, FPX, and credit cards rarely match posted QuickBooks GL cash balances one-to-one, leaving finance teams to manually hunt for timing differences, missing invoices, and FX rounding gaps before period close. ## Core Features & Use Cases - Daily Settlement Reconciliation: Loads GL cash accounts via acct_get_balance_sheet and matches gateway settlement lines to AR receipts and AP disbursements. - Differences List: Partitions every settlement line into matched, unmatched, or exception categories with reason codes such as timing difference, missing invoice, or FX rounding. - Reconciling Item Surfacing: Flags unresolved items before period close so nothing slips into the next accounting period. - Use Case: A finance manager receives the Stripe settlement file for the day, runs the reconciliation, and gets a report showing RM14,800 matched, RM350 in timing differences, and RM80 in FX rounding exceptions. ## Quick Start Reconcile today's Stripe settlement file from the finance gbrain source against the QuickBooks GL cash accounts and list all unmatched items with reasons.

Frequently Asked Questions about bank-payment-reconciliation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I reconcile Stripe settlements with QuickBooks?

Load the Stripe settlement file from the finance gbrain source, pull GL cash balances with acct_get_balance_sheet, then match each settlement line to AR receipts or AP disbursements. The output partitions lines into matched, unmatched, and exceptions.

How to match bank feed transactions to AR and AP records?

Use acct_list_sales_invoices and acct_list_purchase_bills to retrieve posted receipts and disbursements, then match each bank feed or settlement line against them. Unmatched lines are flagged with a reason code such as timing difference or missing invoice.

Why do FX rounding differences appear in payment reconciliation?

Gateway foreign exchange conversion and GL functional-currency rounding leave small residual amounts that never match exactly. Allocate these residuals to a rounding account instead of forcing false matches against unrelated transactions.

When should I not use bank settlement reconciliation?

Do not use it for AR collections dunning, which belongs to ar-credit-control, or for AP payment batching, which belongs to ap-vendor-management. It only reconciles settlement inflows against posted GL cash records.

What tools are required for payment gateway reconciliation?

It requires the existing acct_* MCP contract tools: acct_get_balance_sheet, acct_list_sales_invoices, and acct_list_purchase_bills, plus a gbrain finance source holding settlement truth files. No new payment gateway integration is needed.