|Top Previous Next|
If you are providing book-keeping service, you can very quickly record the purchases in an excel template in each rows and do a batch import into the Purchase Journal
Download a blank template in the Purchase journal, enter the daily purchases of each supplier, the amount , invoice number and date of invoice.
At [A/c Entry] , click [Purchase Journal]
Step 1: Click [Template] to download the excel spreadsheet into your external storage space or your desired folder
Step 2: In this example, the template is stored in an external drive with a file name [Purchase Journal Template] . Click [Save]
Step 3: Open the template and start to enter the sales invoices into the column of template of the customer id, date, reference number, invoice amount.
Once complete, click [Save As] with a different file name, example [ Purchase Journal Template May 2019]
Step 4: Return back to Purchase Journal, click [Import]
Select the excel file [Purchase Journal Template May 2019]
 Click [Save] If your information is not complete, you will have the following message  . Click on the [Missing List] tab 
Return back to your excel spreadsheet. Double click to display Column D [CurrencyRate] .Enter the exchange rate . Go to supplier master to add the new supplier [FTC] in US dollar
Step 5: Repeat Step 4 again, at the [Purchase Journal] , click [Import] followed by selecting the file [Purchase Journal Template May 2019]
Notice at Step 3, row 9, you had not entered any accounts code, system will automatically post to D-S099 suspense account. and display the the word at the [Particular] column
Edit the record and enter the appropriate accounts code.
For subsequent import, example for June 2019, if the accounts code remains the same for the same supplier, you can leave it blank, the system will automatically picked from the last accounts code of the same supplier