Hi Jason

To create a General Ledger in Odoo and address the issue with duplicate entries in Account Payable, you can follow these steps:

Vendor Bills: When registering a payment for a Vendor Bill, ensure that you are only recording the payment once. Odoo will automatically create the necessary journal entries for you. Double-check that you are not duplicating the payment entry.

Bank Statement: When reconciling the bank statement in Odoo, be cautious to avoid creating duplicate entries. Here's how you can handle bank statement reconciliation correctly:

​a. Verify the bank statement transactions: Make sure the transactions listed in the bank statement correspond to the actual transactions recorded in your bank account.

​b. Import or enter bank statement lines: Import the bank statement file or manually enter the bank statement lines in Odoo's Bank Statements module.

​c. Reconcile transactions: Match the imported or entered bank statement lines with the corresponding transactions recorded in Odoo, such as customer invoices or vendor bills. Mark the transactions as reconciled to indicate that they have been cleared in the bank statement.

​d. Verify and confirm the bank statement: Once you have reconciled all the transactions, verify the reconciled bank statement and confirm it. This action will finalize the reconciliation process.

Note: Reversing a journal entry generated from a reconciled bank statement is not recommended because it can lead to duplication of transactions and discrepancies in the accounts.

General Ledger: After ensuring that the Vendor Bills and Bank Statements are handled correctly, you can generate a General Ledger report in Odoo to review the account balances. Follow these steps to create a General Ledger:

​a. Navigate to the Accounting module in Odoo.
​b. Go to the "Reporting" menu and select "General Ledger."
​c. Configure the report settings according to your requirements, such as the date range, accounts to include, and other filters.
​d. Generate the General Ledger report.
​e. Review the Account Payable (AP) balances and verify that the Debit and Credit amounts are correct and equalize to $1.

By following these steps and ensuring accurate and non-duplicated entries in Vendor Bills and Bank Statements, you should be able to create a General Ledger with the expected results.