reconciliation

Name: reconciliation
Author: anthropics

2.5kinstalls2.7kforks

How to install reconciliation?

anthropics/knowledge-work-plugins/reconciliation

$npx -y skills add anthropics/knowledge-work-plugins --skill reconciliation

Installs into the current project.

Summary

Reconcile accounts by comparing GL balances to subledgers, bank statements, or third-party data. Use when performing bank reconciliations, GL-to-subledger recs, intercompany reconciliations, or identifying and categorizing reconciling items.

Files · 1

View on GitHub

SKILL.md

1	# Reconciliation
2
3	Important: This skill assists with reconciliation workflows but does not provide financial advice. All reconciliations should be reviewed by qualified financial professionals before sign-off.
4
5	Methodology and best practices for account reconciliation, including GL-to-subledger, bank reconciliations, and intercompany. Covers reconciling item categorization, aging analysis, and escalation.
6
7	## Reconciliation Types
8
9	### GL to Subledger Reconciliation
10
11	Compare the general ledger control account balance to the detailed subledger balance.
12
13	Common accounts:
14	- Accounts receivable (GL control vs AR subledger aging)
15	- Accounts payable (GL control vs AP subledger aging)
16	- Fixed assets (GL control vs fixed asset register)
17	- Inventory (GL control vs inventory valuation report)
18	- Prepaid expenses (GL control vs prepaid amortization schedule)
19	- Accrued liabilities (GL control vs accrual detail schedules)
20
21	Process:
22	1. Pull GL balance for the control account as of period end
23	2. Pull subledger trial balance or detail report as of the same date
24	3. Compare totals — they should match if posting is real-time
25	4. Investigate any differences (timing of posting, manual entries not reflected, interface errors)
26
27	Common causes of differences:
28	- Manual journal entries posted to the control account but not reflected in the subledger
29	- Subledger transactions not yet interfaced to the GL
30	- Timing differences in batch posting
31	- Reclassification entries in the GL without subledger adjustment
32	- System interface errors or failed postings
33
34	### Bank Reconciliation
35
36	Compare the GL cash balance to the bank statement balance.
37
38	Process:
39	1. Obtain the bank statement balance as of period end
40	2. Pull the GL cash account balance as of the same date
41	3. Identify outstanding checks (issued but not cleared at the bank)
42	4. Identify deposits in transit (recorded in GL but not yet credited by bank)
43	5. Identify bank charges, interest, or adjustments not yet recorded in GL
44	6. Reconcile both sides to an adjusted balance
45
46	Standard format:
47
48	```
49	Balance per bank statement: $XX,XXX
50	Add: Deposits in transit $X,XXX
51	Less: Outstanding checks ($X,XXX)
52	Add/Less: Bank errors $X,XXX
53	Adjusted bank balance: $XX,XXX
54
55	Balance per general ledger: $XX,XXX
56	Add: Interest/credits not recorded $X,XXX
57	Less: Bank fees not recorded ($X,XXX)
58	Add/Less: GL errors $X,XXX
59	Adjusted GL balance: $XX,XXX
60
61	Difference: $0.00
62	```
63
64	### Intercompany Reconciliation
65
66	Reconcile balances between related entities to ensure they net to zero on consolidation.
67
68	Process:
69	1. Pull intercompany receivable/payable balances for each entity pair
70	2. Compare Entity A's receivable from Entity B to Entity B's payable to Entity A
71	3. Identify and resolve differences
72	4. Confirm all intercompany transactions have been recorded on both sides
73	5. Verify elimination entries are correct for consolidation
74
75	Common causes of differences:
76	- Transactions recorded by one entity but not the other (timing)
77	- Different FX rates used by each entity
78	- Misclassification (intercompany vs third-party)
79	- Disputed amounts or unapplied payments
80	- Different period-end cut-off practices across entities
81
82	## Reconciling Item Categorization
83
84	### Category 1: Timing Differences
85
86	Items that exist because of normal processing timing and will clear without action:
87
88	- Outstanding checks: Checks issued and recorded in GL, pending bank clearance
89	- Deposits in transit: Deposits made and recorded in GL, pending bank credit
90	- In-transit transactions: Items posted in one system but pending interface to the other
91	- Pending approvals: Transactions awaiting approval to post in one system
92
93	Expected resolution: These items should clear within the normal processing cycle (typically 1-5 business days). No adjusting entry needed.
94
95	### Category 2: Adjustments Required
96
97	Items that require a journal entry to correct:
98
99	- Unrecorded bank charges: Bank fees, wire charges, returned item fees
100	- Unrecorded interest: Interest income or expense from bank/lender
101	- Recording errors: Wrong amount, wrong account, duplicates
102	- Missing entries: Transactions in one system with no corresponding entry in the other
103	- Classification errors: Correctly recorded but in the wrong account
104
105	Action: Prepare adjusting journal entry to correct the GL or subledger.
106
107	### Category 3: Requires Investigation
108
109	Items that cannot be immediately explained:
110
111	- Unidentified differences: Variances with no obvious cause
112	- Disputed items: Amounts contested between parties
113	- *

People who liked this also viewed

6 picks

Type

reconciliation

2.5kinstalls2.7kforks

View on GitHub

How to install reconciliation?

anthropics/knowledge-work-plugins/reconciliation

$npx -y skills add anthropics/knowledge-work-plugins --skill reconciliation

Installs into the current project.

Summary

Files · 1

View on GitHub

SKILL.md

1	# Reconciliation
2
3	Important: This skill assists with reconciliation workflows but does not provide financial advice. All reconciliations should be reviewed by qualified financial professionals before sign-off.
4
5	Methodology and best practices for account reconciliation, including GL-to-subledger, bank reconciliations, and intercompany. Covers reconciling item categorization, aging analysis, and escalation.
6
7	## Reconciliation Types
8
9	### GL to Subledger Reconciliation
10
11	Compare the general ledger control account balance to the detailed subledger balance.
12
13	Common accounts:
14	- Accounts receivable (GL control vs AR subledger aging)
15	- Accounts payable (GL control vs AP subledger aging)
16	- Fixed assets (GL control vs fixed asset register)
17	- Inventory (GL control vs inventory valuation report)
18	- Prepaid expenses (GL control vs prepaid amortization schedule)
19	- Accrued liabilities (GL control vs accrual detail schedules)
20
21	Process:
22	1. Pull GL balance for the control account as of period end
23	2. Pull subledger trial balance or detail report as of the same date
24	3. Compare totals — they should match if posting is real-time
25	4. Investigate any differences (timing of posting, manual entries not reflected, interface errors)
26
27	Common causes of differences:
28	- Manual journal entries posted to the control account but not reflected in the subledger
29	- Subledger transactions not yet interfaced to the GL
30	- Timing differences in batch posting
31	- Reclassification entries in the GL without subledger adjustment
32	- System interface errors or failed postings
33
34	### Bank Reconciliation
35
36	Compare the GL cash balance to the bank statement balance.
37
38	Process:
39	1. Obtain the bank statement balance as of period end
40	2. Pull the GL cash account balance as of the same date
41	3. Identify outstanding checks (issued but not cleared at the bank)
42	4. Identify deposits in transit (recorded in GL but not yet credited by bank)
43	5. Identify bank charges, interest, or adjustments not yet recorded in GL
44	6. Reconcile both sides to an adjusted balance
45
46	Standard format:
47
48	```
49	Balance per bank statement: $XX,XXX
50	Add: Deposits in transit $X,XXX
51	Less: Outstanding checks ($X,XXX)
52	Add/Less: Bank errors $X,XXX
53	Adjusted bank balance: $XX,XXX
54
55	Balance per general ledger: $XX,XXX
56	Add: Interest/credits not recorded $X,XXX
57	Less: Bank fees not recorded ($X,XXX)
58	Add/Less: GL errors $X,XXX
59	Adjusted GL balance: $XX,XXX
60
61	Difference: $0.00
62	```
63
64	### Intercompany Reconciliation
65
66	Reconcile balances between related entities to ensure they net to zero on consolidation.
67
68	Process:
69	1. Pull intercompany receivable/payable balances for each entity pair
70	2. Compare Entity A's receivable from Entity B to Entity B's payable to Entity A
71	3. Identify and resolve differences
72	4. Confirm all intercompany transactions have been recorded on both sides
73	5. Verify elimination entries are correct for consolidation
74
75	Common causes of differences:
76	- Transactions recorded by one entity but not the other (timing)
77	- Different FX rates used by each entity
78	- Misclassification (intercompany vs third-party)
79	- Disputed amounts or unapplied payments
80	- Different period-end cut-off practices across entities
81
82	## Reconciling Item Categorization
83
84	### Category 1: Timing Differences
85
86	Items that exist because of normal processing timing and will clear without action:
87
88	- Outstanding checks: Checks issued and recorded in GL, pending bank clearance
89	- Deposits in transit: Deposits made and recorded in GL, pending bank credit
90	- In-transit transactions: Items posted in one system but pending interface to the other
91	- Pending approvals: Transactions awaiting approval to post in one system
92
93	Expected resolution: These items should clear within the normal processing cycle (typically 1-5 business days). No adjusting entry needed.
94
95	### Category 2: Adjustments Required
96
97	Items that require a journal entry to correct:
98
99	- Unrecorded bank charges: Bank fees, wire charges, returned item fees
100	- Unrecorded interest: Interest income or expense from bank/lender
101	- Recording errors: Wrong amount, wrong account, duplicates
102	- Missing entries: Transactions in one system with no corresponding entry in the other
103	- Classification errors: Correctly recorded but in the wrong account
104
105	Action: Prepare adjusting journal entry to correct the GL or subledger.
106
107	### Category 3: Requires Investigation
108
109	Items that cannot be immediately explained:
110
111	- Unidentified differences: Variances with no obvious cause
112	- Disputed items: Amounts contested between parties
113	- *

People who liked this also viewed

6 picks

Type