Assign branch level general ledger accounts

You can override the settings in the G/L Control Table and assign transactions to post to separate General Ledger accounts at the branch level.

If you need to create additional General Ledger accounts for these transactions, see Maintain your general ledger accounts.

Adding a Branch G/L Suffix will create subaccounts from the existing General Ledger accounts in the control table, using the two digit suffix to distinguish between branches. These new G/L accounts will appear in the General Ledger Inquiry.

For example, in the Control Table, if your Freight Out is account number 52100000, then the subaccount for branch 02 will be 52100200. The system will create additional G/L accounts as transactions are posted from the branch. The advantage of using the suffix is that it allows you to create branch-specific financial reports.

You will need to assign each new account to a G/L Group manually before you run your financial reports. If you are creating individual reports for each branch (such as branch-specific Income Statements), be sure to assign the account to the appropriate groups for both the individual report and the consolidated report. For more information, see Create branch specific financial reports.

Warning!
You may read on to learn about branch specific general ledger accounting, but do not continue to modify any G/L Account information without first consulting with a DDI Customer Care representative.

1. Go to File > Company > Branch.
2. In the Branch box, click and choose the Branch for which you want to assign G/L Accounts.
3. Click Edit.
4. Click the General Ledger tab.

   

5. In the Branch G/L Suffix box, type the 2-digit suffix that will identify these GL Account as branch-specific. Assigning this suffix automatically creates separate subaccounts for this branch, enabling branch specific financial reporting.
6. In each of the G/L Account categories listed below, click and choose the account you want to associate with this branch.

   Choose as many or as few are applicable. Whatever is not assigned here will default to the settings in the General ledger control table.

   • Sales G/L The reference code and name of the default G\L Account for sales for the branch.
   • POS Sales G/L The reference code and name of the default G\L Sales Account for point of sale orders for the branch.
   • Sales Returns G/L The reference code and name of the Sales Returns G\L Account for the branch.
   • Drop Ship Sales G/L The reference code and name of the default G\L Account for drop ships orders for the branch.
   • Cost of Goods Sold G/L The reference code and name of the default Cost of Goods Sold G/L Account for transactions for the branch.
   • Drop Ship of Cost of Goods Sold G/L The reference code and name of the default Cost of Goods Sold G\L Account for drop ship transactions for the branch.
   • A/R Bank G/LThe reference code and name of the default G/L Bank Account for cash and checks received by the branch. All bank transactions will post to this account instead of the bank listed in the G/L Control Table.
   • A/P Bank G/LThe reference code and name of the default G/L Bank Account for payments made by the branch. All bank transactions will post to this account instead of the bank listed in the G/L Control Table.
   • POS Cash G/L The reference code and name of the default G\L Account for point of sale cash sales for the branch.
   • POS Check G/L The reference code and name of the default G\L Account for point of sale check sales for the branch.
   • POS Bank G/L The reference code and name of the default G\L Account for point of sale cash sales for the branch.
   • POS Visa/MC G/L The reference code and name of the default G/L account for orders paid by Visa or Mastercard for this branch.
   • POS Amex G/L The reference code and name of the default G/L account for orders paid by American Express for this branch.
   • POS Discover G/L The reference code and name of the default G/L account for orders paid by Discover for this branch.
7. Click Save.

See also

• General ledger control table
• General ledger re-indexing
• Create branch specific financial reports