Create Sales Journals
Sales Journals are created in CommerceExpert/WebClerk in order to update the accounting package. The accounts updated by the Sales Journals are primarily the "Inventory Asset", "Sales Revenue", and the "Cost of Goods Sold" accounts.
Creation of the "Sales Journals" calculates the G/L distribution for a group of Invoices. Each Invoice is individually distributed along with a summary of the total distribution to each account affected. A"Text" file is created when the "Sales Journals" are created. This file may be opened in Excel or other text programs, in version 5.0 of CommerceExpert/WebClerk you can use 4D Write or 4D Calc to viewed and/or print these Journals. These text files are your audit trail to the transaction level. They do not have to be printed, but they must be kept.
"Sales Journal Lines" are created in CommerceExpert/WebClerk with summary information. A report may be printed from the "Sales Journal Lines" to prepare Journal entry into the accounting package (as opposed to printing the Text file from Excel). Then, the "GL Journals to accounting package" feature may be used to prepare the "Sales Journal Lines" for direct Import into your accounting package.
Create the Sales Journal
Admin Dept > Acct Menu > Create Sales Journal
The "File Selection" box will appear with all unjournalized Invoices as the current selection. If you want to change the selection, click on" Search". The "Search Editor" will appear.
Click on "OK" in the "File selection" box once you have the desired set of Invoices to Journalize.
A box will appear asking you to name the "Sales Journal". It defaults to "SJ - Current Date". You may change the name but please note the name and location to which you are saving the file.
After naming, click on "Save". The conversion of Invoices will begin.