Balanced Journal Entries for Ledger Sync (QuickBooks)

    1

    The accountant works from the ledger, so what they need from your billing system is the ledger movement, not every customer record copied into a second system.

    $29

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Balanced Journal Entries for Ledger Sync (QuickBooks)

    Example session with this skill installed

    Generate a journal entry for a revenue run totaling 50000 cents, with 45000 cents in 'water_revenue' and 5000 cents in 'tax_payable' using mapping.json.

    • Read your context and instructions
    • Compiled the balanced journal entries

    Processed revenue run for period. Verified totals against mapping rules. Generated QuickBooks-ready payload with deterministic DocNumber and idempotency key.

    Journal Entry Result

    FieldValue
    StatusBalanced
    Total (USD)$500.00
    DocNumberREV-20231027-8A3B
    IdempotencyKeyrun_592_post_20231027
    MemoRevenue Run: water_revenue, tax_payable
    {
      "docNumber": "REV-20231027-8A3B",
      "date": "2023-10-27",
      "memo": "Revenue Run: water_revenue, tax_payable",
      "quickBooks": {
        "Line": [
          {
            "Description": "Total Receivables",
            "Amount": 500.00,
            "DetailType": "JournalEntryLineDetail",
            "JournalEntryLineDetail": {
              "PostingType": "Debit",
              "AccountRef": { "value": "1200" }
            }
          },
          {
            "Description": "water_revenue",
            "Amount": 450.00,
            "DetailType": "JournalEntryLineDetail",
            "JournalEntryLineDetail": {
              "PostingType": "Credit",
              "AccountRef": { "value": "4000" }
            }
          },
          {
            "Description": "tax_payable",
            "Amount": 50.00,
            "DetailType": "JournalEntryLineDetail",
            "JournalEntryLineDetail": {
              "PostingType": "Credit",
              "AccountRef": { "value": "2100" }
            }
          }
        ]
      }
    }
    

    Next steps

    1. Store the idempotencyKey in your database with a status: sending flag.
    2. POST the quickBooks object to the /journalentry endpoint.
    3. Update your record to status: posted upon success or 409 Conflict.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    The accountant works from the ledger, so what they need from your billing system is the ledger movement, not every customer record copied into a second system. Two things then have to be exactly right: the entry must balance in whole cents before it is sent, and nothing may post twice, because a retried timeout that creates a second entry is a duplicated month of revenue found in an audit rather than a log.

    Mapping (createLedgerMapping): declare purposes (receivables, cash, one revenue purpose per category, an optional fallback, tax payable) and take the account ids the customer chose in a settings screen; missingRequired drives the screen. Nothing guesses an account: a recognised category without a mapped account refuses with ACCOUNT_NOT_MAPPED and the purpose, instead of posting to "other" balanced and accepted with no warning.

    Revenue run (buildRevenueEntry): one credit per category with the period in the description, tax as its own credit only when billed, and a debit to receivables equal to the sum of the credits, compared with the run's stored total; a disagreement is refused with both numbers (TOTALS_DISAGREE), never reconciled.

    Payments (buildPaymentsEntry): one entry per day, cash debited and receivables credited, the method breakdown checked against the total.

    finalise: the only exit of every builder; refuses unbalanced, empty, zero-amount, unaccounted, undated or oddly numbered entries; converts cents to dollars exactly once; returns the neutral lines, a deterministic docNumber and idempotencyKey, and the QuickBooks Online JournalEntry body.

    CLI (journal-cli.mjs) and 8 tests (split by category, tax present and absent, totals disagreement, unmapped and unknown categories with and without a fallback, payments with breakdown checks, odd cents and large amounts, every finalise refusal, the CLI). reference/posting-rules.md covers the two invariants, the idempotency record and mapping other ledgers. Node 18+, no packages, no network. Engineering guidance, not accounting advice.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.

    Supports revenue runs and daily payments only. Excludes refunds and write-offs. Requires Node 18. Developer must implement the network transport layer.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 17 days ago

    Software
    Node.js 18+

    Permissions

    Read Files
    Write Files
    Listed17 days ago

    What's inside

    Frequently Asked Questions

    This skill provides a dependency-free Node.js logic layer that converts billing data into balanced journal entries. It specifically prevents common accounting errors like floating-point rounding issues, unbalanced debits/credits, and duplicate posts through strict mathematical validation and idempotency keys.

    The skill is designed for Node.js 18+ environments and works with any AI agent or automation platform capable of executing JavaScript. While it generates payloads pre-formatted for QuickBooks Online, the underlying logic can be adapted for any ledger that accepts JSON-based journal entries.

    You will receive the core logic module (MJS), a configuration utility for account mapping, a CLI tool for manual processing, and a suite of eight verification tests to ensure the logic remains sound within your specific environment.

    This skill focuses exclusively on the logic and validation gate to ensure data integrity. You will need to use your existing API integration or an AI agent's networking capabilities to physically transmit the validated JSON payload to your accounting software's endpoint.

    To maintain high reliability, the skill uses integer-based math in whole cents rather than standard floats. It requires you to define specific account mappings upfront, and it will intentionally error out if it detects a mismatch between source totals and individual line items, preventing corrupted data from ever reaching your ledger.

    New in Finance & Accounting