Posted by Cherilyn_CO on 11/16/05 2:30pm
Msg #77006

Who uses a spreadsheet to track signings?

I've been fiddling with mine and would like to compare with others who use the same type of thing. What info. does yours contain and what do you use the most?

Here are my columns:
1)Company
2)Company Contact
3)Company Phone number
4)Signing Date
5)Borrower's Last name
6)address
7)Fee
8)Milage
9)# of notarizations
10)Formula multiplying the above with $5.00 for notary income
11)Formula for self employment income #7-#10
12)Date Paid
13)Formula subtracting #12 from #4 to find how long it took them to pay me or how far past 30 days they are.

I don't really use #2 & #3 so I think I'm going to get rid of them. At the bottom of my SS, I have statistical calculations for each month. I really like #13 as I can tell right off the bat who owes me $ and who the slow payers are :-) Don't know if I need the Fed Ex or UPS tracking #.

Anyone have anything that I should add? Or some fun formulas? I need to add my expenses somewhere too, but not sure where.

Reply by Nate_MN on 11/16/05 4:10pm
Msg #77040

I use a spreadsheet as well. Mine has about he same, leaving out the formula multiplying the # of notarizations by $5.

In addition, I track time it takes to perform each closing, hourly rate, vehicle expense (which I get my per mile expense from a different spreadsheet tracking all repairs and maintanence on my vehicle. And finally profit margin.

Reply by Genkichan on 11/16/05 4:15pm
Msg #77041

I use a spreadsheet. I keep my tax deduction/expenses on the left and a general list of signings on the right. For the signings, I put in separate columns, left to right:

date, company that hired me, notary fees, signing fees, title/lender info, date paid, and comments. I use "add comment" to the cells "date", "hiring company", and "title/lender info". and then I add borrower's last name and contact info for each cell, respectively.

It's really pretty basic. I will probably go back in and add a milleage collumn for easy calculations later on. Just a data entry exercise that I've been too lazy to do! My signing log book has much of the same information, and I like to have it in two locations.

I have running totals at the top of the spreadsheet that indicate total notary fees, total signing fees, total taxable income with and without SE tax, etc.

Since I'm just a part-timer, I haven't gotten to be too sophisticated about it. But, the excel tool makes it easy to keep track of things and have running totals throughout the year. I'm sure there is much better software out there for this. Maybe someday...... ;-) *grin*

Happy signing!
Vicki/MD

Reply by Nd_WA on 11/16/05 6:08pm
Msg #77062

Email me at the below address and I'll send you my template.

[e-mail address]

Reply by SignerCA on 11/16/05 6:14pm
Msg #77065

I use the Notary Signing Agent Log I received from the NNA, works for me.

Reply by Art_MD on 11/16/05 8:32pm
Msg #77088

I have a column for mileage to drop off packages. If I drop off 2 the same time, one signing gets 0 miles. All is tax deductable expense.

Also use a column with a formula: If there is no date paid entered, then the fee amount, else if there is a date, 0. Total of column is accounts receivable. Helps at tax time sine isn't income until received (if on a cash accounting basic)

Also, date paid column has a conditional format - if today minus date signed is >45, cell is red, else is clear. Quickly can see overdue payments.

Art