USA accounting 101

Joined
May 10, 2018
Messages
2
Reaction score
0
Country
United States
I'm new here, I have been doing accounting for a small fire district for a couple years now. This question will likely make most of you laugh at me! Let just say: teenagers, drivers test, quarterly closing and audit prep have me fried. Here is my problem

Its a simple problem, but for the life of me I cannot see the solution.... I think I might delete it and start again... But I don't want to have to do that.
Right now for AR we use an excel tracking log and the Sales module in GP for deposit. We don’t do a ton of AR. Invoicing for some re-bills, some county funds, and misc.

The process is: create an invoice, log it on the excel sheet, receive $$, create a deposit in the sales module (in GP), update the excel, then manually do the following J/E’s

1)

1120-001 (debit to AR)

7530-001 (credit to the expense or rev)

2)

1025-001 (debit to a cash clearing)

1120-001 (credit to AR)

3)

1020-001 (debit to cash)

1025-001 (credit to the cash clearing)

It’s a major PITA and we WILL be moving to use GP solely for invoicing and tracking next FY.


THIS is my issue..
I’ve created an invoice, logged it on our AR log in excel, received the payment, and used the Sales module to deposit it, but i ONLY did these two J/E’s

1)

1025-001 (debit to cash clearing)

6030-001 (credit to rev or exp)

2)

1020-001 (debit to cash)

1025-001 (credit to cash clearing)



THE PROBLEM with the above is that I haven’t figured out the J/E to get the darn thing into and out of AR in GP

I’m thinking that if I do the deposit as above I need to create 2 additional J/e to show it in AR and take it out?? Or back out this sales J/e and do it again like the first scenario? Ugh…. I know it’s a simple fix, I just can’t see it.

Thank you anyone who can give me some advise!
Burgen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
11,753
Messages
27,799
Members
21,755
Latest member
MelanieS

Latest Threads

Top