Acumatica makes it easy to create journal entries. In this video, we will see two shortcuts that save time. The copy/paste function allows you to eliminate some data entry when you have similar transactions. You can use the transaction upload feature to quickly bring data from Excel into Acumatica. For example, if you have similar transactions each week but the dollar amount changes, you may find it easier to update the data in Excel, then bring that information into Acumatica to create the journal entry.

Watch the video: Quick Look at How to Create an Acumatica Journal Entry – Copy/Paste from Excel and Transaction Upload Features

Video Transcription:

“I want to show you some of the power that Acumatica has to be able to quickly create entries so that you don’t have to do things manually. We’re going to use a previous journal entry GL 1436 as the basis for these new entries that we’re going to be creating here.

The first thing I want to show you is the copy/paste function here. If you have an entry that perhaps you’ve created before, and you just want to quickly take a copy of that and create a new one so you don’t have to manually key it in, you can use this copy function that you see highlighted on the screen. All you do is you select copy once you have that journal transaction pulled up, you hit the plus button, and then we’re going to go back to that little clipboard and we’re going to say Paste and there’s your entry. It’s as easy as that to take a previous entry copy and paste it. Now, if your debit or credit amounts happen to be different, you certainly have the opportunity before you go ahead and finalize and release this transaction, you have the opportunity to change those debit or credit amounts.

One thing that you’re going to see throughout the system on any transactions is a button called Release. For people that have used other systems in the past, a lot of times other systems call that as posting. Acumatica’s term “Release” equates to that posting term that you may be acclimated or familiar with from other systems. Once the transaction is released, it’s finalized, because this is a gap compliant system, you can’t make any changes to our release transaction.

While this is releasing, the other way we can quickly create a transaction so we don’t have to do manual entry is to use the Transaction Upload functionality. We already have an Excel file prepared with all of our distribution detail in that. And we’re going to use this File Upload function to quickly take the information from that Excel file and bring that in Acumatica.

We’re navigating out to that previously saved Excel file, and we’re going to hit the upload button and click OK to these common settings. Here is basically our mapping, so it’s mapping the column names in the Excel files to the same column names that it’s finding in this journal transaction. As long as those column names are one and the same, the mapping happens automatically, and you can just take what’s defaulting in, click OK and it’s going to upload that transaction.

Again, this is great where you might have similar transactions week after week or month after month, but maybe the dollar amounts change. I find that it’s easier to update dollar amounts in Excel instead of doing it right here in Acumatica. That’s where this upload functionality comes in hand where you can update your dollar amounts and that file that you used over and over again, update them in Excel, and then upload them automatically through this upload function. We can go ahead and we’ll just release this transaction, as well.”

This is a snippet from a detailed Acumatica overview. Watch the full video – Acumatica Lunch and Learn Part 2 – Acumatica Financials.

If you want to see more features that stand out in Acumatica review the series of articles our senior ERP consultants have published that compare Acumatica vs Microsoft Dynamics GP.

Get Acumatica user tips at

Are you ready to evaluate Acumatica or looking for Acumatica training and support? Contact CAL Business Solutions at or 860-485-0910 x4.

By CAL Business Solutions, Acumatica and Microsoft Dynamics GP Partner,

Acumatica Journal Entry - Compare Acumatica versus Dynamics GP