PhreeBooks uses journals to hold transaction information. Every type of transaction includes an unique journal ID to indicate the type of transaction. The table below describes the journal ID's and their definitions. All journal entries are stored in a two database tables, journal_main and journal_item. Table journal_main contains the general information regarding the transaction, table journal_item contains the line items associated with a transaction. For example, an invoice will contain a single journal_main record and several journal_item records. The journal_item record will have a record for the invoice total, one record for each sales tax authority, one record for shipping charges, and one record for each line item in the invoice.
Journal ID |
Transaction Type |
Description |
2 |
General Journal | This journal records transaction directly to the general ledger. Costs are credited or debited directly to the selected general ledger accounts. |
3 |
Purchase Quote Journal | Used to record quotes to vendors for purchases. |
4 |
Purchase Order Journal | Used to record purchase orders placed with vendors. |
6 |
Purchases Journal | Used to record items/action received from vendors. May or may not impact inventory. Items need net be physical, they may be bills received from vendors for services, etc. |
7 |
Vendor Credit Memo Journal | Used to record credit memos for vendors for items returned. |
8 |
Payroll Journal | Not used at the present time. Reserved for future payroll functionality. |
9 |
Sales Quote Journal | Used to record quotes to customers. |
10 |
Sales Order Journal | Used to record sales orders placed by customers. |
12 |
Sales/Invoice Journal | Used to record sales of items, services, etc. to customers. |
13 |
Customer Credit Memo Journal | Used to record returns by customers. |
14 |
Inventory Assembly Journal | Used to record inventory items assembled. The inventory item must be of type Item Assembly. |
16 |
Inventory Adjustment Journal | Used to record inventory adjustments. Adjustments may be positive (extra inventory) or negative (inventory loss due to pilferage, damage, etc.) |
18 |
Cash Receipts Journal | This journal is used for all customer receipt type transactions. It is also used for Vendor Credit Memos. |
19 |
Point of Sale Journal | Not used at the present time. For direct sales, enter the items through the sales/invoice journal and select the payment button to post the transaction and proceed to the payment receipt operation. |
20 |
Cash Distribution Journal | This journal is used for all vendor payment type transactions. It is also used for Customer Payment entries. |
21 |
Point of Purchase Journal | Not used at the present time. For direct purchases, enter the items through the purchase/receive journal and select the payment button to post the transaction and proceed to the payment operation. |
22 |
Shipping Journal | Not used at the present time. This function is handled through the Shipping Manager. |