INSTRUCTION MANUAL
PAGE 3
INVENTORY IN and OUT JOURNALS and INVENTORY REPORT
INVENTORY IN and OUT JOURNALS and INVENTORY REPORT
INVENTORY IN/RECEIVED JOURNAL
This is where you will encode or record quantities of your inventory items as Inventory Received/In. Inventory-Out has separate Journal looks the same as this one (sample not shown) where you encode your Inventory-Out or sold. The price of each item will be encoded separately in the Reports Inventory Sheet. Items and Code can be change by its name or whatever Code you prefer. Changing these Items and Codes in the January Sheet will reflect changes made in all sheets (Feb-Dec) and SUM Sheet.
TO INSERT COLUMNS (In this case the Inventory Received Journal)
In case more than the 100 Inventory Items are needed. At the January Sheet add items and code in BB, BC and so on columns depending on how many columns you wish to add. In the Feb – Dec Sheet, drag these Cells to effect changes. At the Total, Row 105, Column BA, drag it up to the columns that were added. Do this step in the Feb – Dec and SUM Sheets. At the Reports, Inventory Sheet, and drag to copy formula LINKs. CHANGE the Letters of the column to where it supposed to be LINKED. Take note of the succession of the LETTERS of the columns inserted.
Then, in the Reports Inventories Sheet, Insert rows for the added columns then LINK the added column of Codes and Items, by dragging DOWN the last cell to the number of cell added then change the LETTERs of the formula in succession, from BA to BB, BC, BD and so on depending on the number of columns added in the Inventory Journal. In the column IN and Out, also drag the cell down from the last cell to how many cell were added and change the succeeding LETTERs the same way from AY, AZ, BA, BB and so on. Drag the last cell of the Cost, Sale and Inventory Cost Column down to the number of cells added in the adjacent column. (The same steps are applicable to other Journals in inserting additional columns).
TO INSERT ROWS (In this case the Inventory Received Journal)
In case more than 101 entries are needed each month, just drag down from Row 104 before the Total up to the desired number of Rows to be added and then insert. Do this step from Jan-Dec Sheets. These inserted Rows will automatically reflect in the SUM Sheet. (The same steps are applicable to other Journals in inserting additional ROWS).
TO INSERT COLUMNS (In this case the Inventory Received Journal)
In case more than the 100 Inventory Items are needed. At the January Sheet add items and code in BB, BC and so on columns depending on how many columns you wish to add. In the Feb – Dec Sheet, drag these Cells to effect changes. At the Total, Row 105, Column BA, drag it up to the columns that were added. Do this step in the Feb – Dec and SUM Sheets. At the Reports, Inventory Sheet, and drag to copy formula LINKs. CHANGE the Letters of the column to where it supposed to be LINKED. Take note of the succession of the LETTERS of the columns inserted.
Then, in the Reports Inventories Sheet, Insert rows for the added columns then LINK the added column of Codes and Items, by dragging DOWN the last cell to the number of cell added then change the LETTERs of the formula in succession, from BA to BB, BC, BD and so on depending on the number of columns added in the Inventory Journal. In the column IN and Out, also drag the cell down from the last cell to how many cell were added and change the succeeding LETTERs the same way from AY, AZ, BA, BB and so on. Drag the last cell of the Cost, Sale and Inventory Cost Column down to the number of cells added in the adjacent column. (The same steps are applicable to other Journals in inserting additional columns).
TO INSERT ROWS (In this case the Inventory Received Journal)
In case more than 101 entries are needed each month, just drag down from Row 104 before the Total up to the desired number of Rows to be added and then insert. Do this step from Jan-Dec Sheets. These inserted Rows will automatically reflect in the SUM Sheet. (The same steps are applicable to other Journals in inserting additional ROWS).
INVENTORY REPORT
DAILY INVENTORY REPORT is Automatically Generated Report where you can PRINT or view End Balance of your Inventory, Cost of Sales and Inventory Cost. Unit Cost of each inventory item must be encoded. Beginning Balances are remaining inventories from previous year report or inventories prior to this Accounting Program and must be encoded. Order Point is determined and just encoded.