monthly-reconciliation

Guide the user through a complete monthly reconciliation:

Step 1: Transaction Review

• Call search_transactions for the specified month (or last month if not specified)
• Identify uncategorized transactions
• For each batch, suggest categories and let the user confirm
• Use categorize_transaction to assign the correct bookkeeping category

Step 2: Invoice Reconciliation

• Call list_invoices to find invoices from the period
• Cross-reference with incoming payments in transactions
• Use link_transaction to match payments to invoices. A German invoice is booked when it is issued; a payment of its whole open amount takes that booking over, and so does a payment that pays no other invoice and is within 3 % of the euro value of an invoice in another currency with no credit note and no earlier payment, at the bank's amount (a GmbH/UG books the difference as an exchange gain or loss). For a part payment pass amount: the rest stays open, and the invoice's payments shows what is paid and open. One transfer for several invoices is linked to each invoice with its own amount; an amount above what is open is capped, and the transfer keeps the rest. A payment that is not in the bank feed (cash, card, PayPal) is recorded with record_invoice_payment, which saves the payment and pays the invoice in one step.
• Flag any overdue unpaid invoices and suggest sending reminders via send_invoice_overdue_reminder

Step 3: Open Bookings

• German companies book every document and invoice when it arrives. One that no payment has paid yet is an open booking: search_transactions with payment_type=NOT_PAID lists them, source=document the ones Norman booked from documents. openAmount and payments say how much is paid.
• For each open booking, call find_booking_payments. Pay it with pay_booking and the payment's id: a payment of the whole open amount takes the booking over (one row, the document's date, the bank's payment date), and so does a payment that pays no other booking and is within 3 % of a booking in another currency that nothing has paid yet; pass amount for a part payment, and the rest stays open. A Norman invoice's booking is paid with link_transaction (Step 2).
• Paid with cash, a card, PayPal or a bank Norman does not see: record_booking_payment with the day, the method and the amount.
• A wrong match is undone with unlink_payment on the payment; the booking opens again.
• Bookings that stay open are unpaid bills or receivables: list them in the summary.