QuickBooks Tip: Memorized Transactions
March 14th, 2007 by Matt InglotI recently wrote about staying on top of your company’s books and the tremendous information gains that result. I’m now in the process of analyzing my company’s 2006 year and learning a great deal about how the actual performance matches my expectations. One of my areas of needed improvement is bookkeeping - I am looking to reduce time spent bookkeeping, reduce the time it takes to get accurate statements of past performance, and to increase the amount of information that I can obtain from my books. To accomplish this goal I have been working on improving the ways I do my books, and have been learning some neat tricks in the process.
After a trip to the accountant’s last month I was introduced to a terrific QuickBooks feature for dealing with a nuisance of mine - entering repeat transactions. I have a number of clients on a monthly billing cycle for recurring services, and until now I have been entering each such transaction into QuickBooks manually. I’ve become quite good at it, but I can’t emphasis how much of a timewaster it has been each month.
Memorizing a Transaction
The simple trick here is to have QuickBooks do most of the work for you. Let’s say you have a client that is billed $150 per month for some sort of recurring service, and that you invoice this client monthly. If this is a new client, enter the first invoice manually as you would always do. If this is a past client simply bring up the last invoice. With the invoice open, you will find a Memorize Invoice option hiding in the Edit menu. This will allow you to have QuickBooks either enter the transaction automatically every “xx” amount of time, or set it as a task in reminders (this is your only option if you work with foreign currency, however the invoice is still automatically filled in for you). The same applies for other QuickBooks transactions too, most notably bills.
Now when I need to make my regular invoices or pay regular bills I simply click the transaction reminder for that bill and QuickBooks does the rest. The speed difference is incredible, and it’s always comforting to reduce the chances for human error through automation.
Compatibility Note: I write this from the perspective of the QuickBooks 2006 Canadian Pro edition, but I suspect that other QuickBooks versions and competing accounting packages have similiar functionality.
Got something to say? Leave a response to this post.
Get the latest updates by subscribing to the feed.
Semi-Related Posts



del.icio.us
digg
Reddit

April 10th, 2008 at 4:03 am
My-Personal-Growth.com…
Think of the worst situation that can result after the self- improvement. Try to find various solutions to it. Reflect on how much you can loose, if the worst happened, and how important those things are to you. If you find more than one reasonable sol…
June 9th, 2008 at 5:18 pm
Thanks for the post on QB. I am using the memorized invoice feature on QB for the first time, and I noticed that the future scheduled invoices do not automatically appear in invoices or in the customer balance. Do you simply have to wait until the day the invoice is supposed to drop to see if it will be created, or is there a way to see if the feature actually worked? Seems like if I have to write them all down and check them manually on the 1st, then it doesn’t save much time. Am I missing something?
June 10th, 2008 at 9:31 am
I believe there is an option to have them created automatically when setting up the memorized transaction (as long as it’s not foreign currency).
October 5th, 2008 at 9:49 pm
spot forex…
« FOREX- Dollar climbs as US lends hand to Fannie, Freddie- 華富財經 Forex Options: 3- Month Dollar/ Yen Options Up Despite US Steps- Smartmoney. com» 13 07 2008 A new Forex trading website provides information about forex… - WebWire (press rel…
October 7th, 2008 at 3:25 am
foreign currency trading…
Are you thinking of going long? DON\’T EVEN THINK ABOUT IT! As I have said time and again, the market is in a downward bias. it only makes sense for you to short the market. In this trade which lasted for around 40 minutes, I demonstrate how you can …
October 7th, 2008 at 5:35 am
forex micro…
The Forex Mentor Program from Peter Bain is one of the most downloadedForex Training Courses on the internet. Rightfully so, Peter Bain has guided thousands of people toward riches through the wonderful and not- so mysterious world of Forex. At least a…
October 7th, 2008 at 10:18 am
fx blog…
Brazil is one of the world’ s fastest- growing consumer markets and one of the largest for automobile and television manufacturers. But a currency that has gained more than 30 percent in the past two years and more than 100 percent since 2002 has ero…
August 13th, 2009 at 10:08 am
suck it
August 13th, 2009 at 10:08 am
eat some ass tonight!
October 4th, 2009 at 1:25 pm
Thanks for sharing your knowledge. You saved me a lot of time. Keep up the good work.