Imports are one of the most beneficial ways to
save time and make your job
EZier! You don’t have to be an Excel guru – we
use Excel templates (with instructions!) for
Accounts Payables transactions, Revenue
transactions, General Ledger journal entry
SSI’s Excel Import Templates can be found on the
top menu ribbon of your main SSI screen. Look
for the Excel tab and from the
drop down you will see
Start-Up ImportTemplates. That’s your “go-to” for the whole list of
available import templates.
Today we’re talking about transaction templates.
Here’s a list of the Excel transaction templates
and some examples of how these import templates
can make your job EZier!
AP03I – Accounts Payables
One of the most utilized SSI imports. Can be
used for Accounts Payables invoices/credit memos
and for office checks. Especially great for
non-op JIB invoices on the same wells every
month. Fill out the template and import – then
save the template and edit dollar amounts/wells
as needed for the next month’s JIB.
Another much utilized transaction template in
the SSI library. Let’s face it – revenue can be
tedious to enter. It’s the nature of the beast.
All manner of sorting, sub-totaling, etc. can be
done in the Excel template to check your work
and verify accuracy before it’s imported. Save
an existing template by purchaser and just
change what’s necessary for next month’s check.
RP03MI – Revenue Meter
is available to import meter allocation
volumes. Use RP03M – Import -
Well Volumes to import the meter volumes.
If you can get Accounts Payables invoices or
revenue check detail in a digitized format –
even better! Cut/paste into an SSI Import
template. Investing with other SSI clients? Try
SSI Share! Your data comes to you already digitized and
already formatted for importing.
GL03I – General Ledger
Use it for journal entries to well/category,
general ledger accounts or a combo. Can also be
used for Journal Code 65 - Selective Owner
Charge/Credit. Make a separate import
spreadsheet for JC 65 transactions.
JB01I – Recurring Charges
The perfect answer for changes to well/category
overhead charges. Easily update the recurring
charges for new wells being added or
plugged/sold wells that should be
AR03I – Accounts
Receivables Import for Invoices and/or Credit Memos
Great for miscellaneous non-JIB invoices or
credits being booked to Accounts Receivables.
Note – Accounts Receivables payments and
adjustments cannot be imported. Use standard
AR03 for payments/adjustments.
Other great transaction imports:
WM09I – Well Obligations
Integrated with Accounts Payables for payment of
well obligation and updates to AP05 - Vendor
OE03I – Order Entry
For the Order Entry/Service oriented companies.
Works in addition or in place of OE03 Order
SSI recommendation when using Import templates -
start by doing a “save as” on the Start-up
Import template and key your data into the saved
template. Name it anything you want. Doing this
will keep the templates in the SSI Startup
Import Template file pristine, and you’ll always
have a clean “out of the box” template if