"Acumatica has some really powerful tools that really help with day to day efficiencies. Data entry can be daunting sometimes in accounting, especially if you have transactions that are very long entries or transactions that need to import from other systems. So, I'm going to show you how you can accomplish this manually with a general ledger entry.
The first thing that you want to do is determine what the Excel import file format should look like so that when you get ready to do your import, it flows in without any issues or any errors. This is really simple.Let's begin by going into the finance area, and I'm going to go into general ledger journal transactions. You can see that I'm setting on one transaction right now. And what I'm going to do is export this so that I can see what the file requirements are like, in order to do an import—because they're identical.
So I just click on the Excel button, and then it's going to dump a file out for me that I can then open and use as a beginning for a template. So right down here, I'm going to select "file open," and let me bring this over here to the screen for you. And you can see that, for this journal entry, fields that are available for import are here across the top. Right. And that the standard formatting is that you have your debit and credit accounts with the dollar amount, and then whatever you want the transaction description to be.
So, what I've done in preparation for this little tip today is I've already created a journal entry that has many lines on it. So I'm going to close to this, and here's what I set out for our discussion today. So, I've got a journal entry that has, let's see how many lines did I create in this, 70 lines with associated debits and credits, using that same template style that we had before. So, this journal here called General Ledger journal entries for we're going to import.
Just save this out and close it. Now we're ready to do our import. This is very simple. What I'm going to do is create a new journal entry,and then I'm going to tell it that I'm going to load records from a file. Choose my file, General Ledger journal entry, we'll open in, and we're going to tell it to upload. We'll take the default and, of course, because I started with an export, and I was assured of what my mapping should be, I don't have to worry about mapping any of this. So, I can just check all the defaults here as well.Click on 'OK.' You can see up here that it's importing the transaction. This one has 71 lines. You can see it came in very quickly. It came in as a total debit of 60,510 credit and 60,510, and there are all of those transactions. And now it's sitting here ready for you to post it. The nice thing about this with Acumatica is that this same process of being able to export a transaction, so that you can see what the template requirements are for import, and the upload is the same throughout the system. So this same process that I just showed you for general ledger will also work for accounts receivable, accounts payable,and all the other transaction detail modules. It's as simple as that."
Sheri Blaho is the Vice President of Sales and Marketing for CS3 Technology. Her education as an accountant combined with her years of system design and programming gives her a unique perspective that is a great advantage for all customers. While primarily focused on HR, Payroll and Time Collection systems, she can answer questions regarding ERP solutions too.