...
- Mandatory Columns in the spreadsheet (use these headers)
- Date (of journal)
- Account (Can be Acct)
- DR (or can use Debit)
- CR ( or can use Credit)
- Optional columns that can may follow mandatory columns in the spreadsheet (use these headers)
- Tax Code
- GST inc (0 or 1) - check with us before using these.
- Link (from list on Journal - Order, Event, Asset, BusinessEntity, StockTranItem, Stock, ItemForSale, CompanyDivision, Brand) - note Brand will link to the supplier.
- Search code (eg for a brand that would be the supplier search code in the system, for Asset it is the Asset Search Code in our system)
- External reference (normally this would hold the reference that was in the old system)
- Notes
- Qty
- Amount
- Note GST is not relevant for General Journals
Once the journal is ready to import
...