Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to import new system opening balances ?
09-10-2016, 10:09 PM (This post was last modified: 09-10-2016 10:12 PM by R2-G.)
Post: #1
How to import new system opening balances ?
Hi,

I created an GL transaction file containing the data (below) from the example
opening balance entry in the manual (Creating a New System)

Debtors Control 5,000.00
Creditors Control (2,000.00)
Motor Vehicles 10,000.00
Loan (3,000.00)
Accum Profits (11,000.00)
Total bank deposit $1,000

and created the csv file below (test-ob.csv)

Date,Account,ChequeNo,Amount,Narrative,Tag
01/09/16,1110,9,5000,Debtors Control,0
01/09/16,2010,10,-2000,Creditors Control,0
01/09/16,1520,11,10000,Motor Vehicles,0
01/09/16,2150,12,-3000,Loan,0
01/09/16,3200,13,-11000,Accum Profits,0
01/09/16,1010,14,1000,Total bank deposit,0

Then did Z_ImportGLTransactions.php and imported the transactions as GL receipts

and got

SUCCESS Report : Batch Import of test-ob.csv has been completed. All transactions committed to the database

all the data looks ok, the right accounts were debited and credited correctly

my question is...
can new real client live system opening balances be entered this way ?
i.e using Z_ImportGLTransactions.php rather then the procedure described
in the manual (Creating a New System)


Thanks in advance


R2-g
Find all posts by this user
Quote this message in a reply
09-10-2016, 11:47 PM
Post: #2
RE: How to import new system opening balances ?
You can but.....

You must also enter the trasactions in the creditors and debtors ledger ensuring the balances agree. Also you jeed to ensure your inventory agrees with the transactions you bought on.

As an accountant my advice is to only enter transactions for the current financial year if you are starting midway, otherwise enter a journal fir the starting TB as per the manual.

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)