Accounts Receivable Via Cash Sales

Accounts Receivable Via Cash Sales

Accounts Receivable Via Cash Sales

I work for a family owned oil corporation. I use Quickbooks Pro 2008. I am having difficulty with the accounts receivable via cash sales. Many of the customers pay in cash. The owner of the corporation (president) has been pocketing the cash and not depositing it into the corporation's checking account.

I've already invoiced out these customers. Because of what she's doing - I can't get the books to balance. No big surprise there. So my question is this - is there some kind of balance adjustment I can do so that there will be a record of the money coming into the corporation's hands & being credited to the customer's account, but not into the checking account??

Comments for Accounts Receivable Via Cash Sales

Average Rating starstarstarstarstar

Click here to add your own comments

Dec 07, 2017
Rating
starstarstarstarstar
Accounts Receivable and Owners Draw
by: Stephanie

Thank you for your question regarding Accounts Receivable Via Cash Sales. There are a few different ways you can account for the cash receipts that are then pocketed by the owner.

Many companies will often setup what they will refer to as a Petty Cash Account that will be used to clear the customer invoice. They can then expense cash purchases through the Petty Cash and any balance at year end would be journal entried out of Petty Cash and into Owner's Draw as follows:

DEBIT Petty Cash (when cash received)
CREDIT A/R (to clear invoice)

DEBIT Expense (type of purchase)
CREDIT Petty Cash (for cash expenditure)

DEBIT Owner's Draw (Equity)
CREDIT Petty Cash (to clear YTD balance)

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Accounts Receivable Questions.

Delinquent Accounts Receivable


If a bookkeeper reviews delinquent accounts receivable and finds that a relative of his has not paid his account of $550, and you know he had been having financial difficulties, so you set his account aside and don't include it with other past due accounts sent to a credit agency, how would you comment on this action?

Comments for Delinquent Accounts Receivable

Average Rating starstarstarstarstar

Click here to add your own comments

Dec 08, 2017
Rating
starstarstarstarstar
Unpaid Accounts Receivable
by: Stephanie

Thank you for your question regarding delinquent accounts receivable from a relative. An owner can provide different terms to different vendors and can designate loans vs accounts receivable.

It sounds like the relatives unpaid balance should be moved and tracked as a loan going forward, if it is going to be treated different that the other delinquent Accounts Receivables.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Accounts Receivable Questions.

Accounts Receivable Accounting Entries On Interest Received

Accounts Receivable Entries On Interest Received

Accounts Receivable Entries On Interest Received

What is the accounts receivable accounting treatment of interest received on a deposit account opened in a private limited company name but operated by a director with his personal fund and for his personal activities?

Comments for Accounts Receivable Accounting Entries On Interest Received

Average Rating starstarstarstarstar

Click here to add your own comments

Dec 07, 2017
Rating
starstarstarstarstar
Accounts Receivable Interest Entry
by: Anonymous

I believe the accounts receivable bookkeeping entry for interest earned and received on a deposit account opened under a LLC name that was funded by the director for personal activities would be to debit the bank and credit Other Income - Interest to distinguish it as personal interest as opposed to business interest.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Accounts Receivable Questions.

Accounts Receivable Issue

by VMILLER
(KILLEEN, TX)

Accounts Receivable Issue

Accounts Receivable Issue

What kind of bookkeeping ledger journal entry would I use for sales that were accounted for in Accounts Receivable on an invoice? The deposits were not applied to the invoices properly but were created anew. This is leaving a balance in the A/R for sales that should not have been put on an invoice.

Comments for Accounts Receivable Issue

Average Rating starstarstarstarstar

Click here to add your own comments

Dec 08, 2017
Rating
starstarstarstarstar
How To Clear Accounts Receivable Issue
by: Stephanie

Thank you for asking about your Accounts Receivable issue. There are several ways to clear the Accounts Receivable balance still showing when deposits are directly expensed instead of flowing through A/R to clear the outstanding invoice.

The first and easiest if possible and applicable, would be to delete the invoice that is creating the outstanding balance. The longer route would be to either edit or delete and re-create the entire transaction.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Accounts Receivable Questions.

Accounts Receivable Refund

Accounts Receivable Refund

Accounts Receivable Refund

How do you go about posting a refund to Accounts Receivable?

Comments for Accounts Receivable Refund

Average Rating starstarstarstarstar

Click here to add your own comments

Dec 08, 2017
Rating
starstarstarstarstar
Accounts Receivable Refund Posting
by: Stephanie

The way to post an Accounts Receivable refund is by using the General Journal in which you would debit Accounts Receivable and credit the online business bank account.

If you are using Quickbooks, Use the Create Credit Memos/Refunds window to issue a credit memo or refund check when a customer returns items for which you have already recorded an invoice, customer payment, or sales receipt.

Go to the Customers menu and click Create Credit Memos/Refunds. In the Customer:Job field, choose the customer and job for which you are creating the credit memo or refund check.

Important: If you have created more than one job for the customer, be sure to assign the credit memo to the correct job. You can apply the credit memo only to the same job for which it was created.

Select a template. Click the Account drop-down list and choose which Accounts Receivable account to use. This field appears only when you have more than one accounts receivable account (most companies have only one).

Enter the items being returned in the line item area. Use the same information that was on the original invoice or billing statement. QuickBooks decreases the income accounts of the invoice items by the amount of the return.

(Optional) Assign a class to this credit memo. (Optional) In the Customer Message field click a message from the drop-down list, or enter a new message to your customer.

(Optional) Enter a memo for this transaction. The memo does not print on the credit memo, but it does appear in the Accounts Receivable register and in the customer register.

(Optional) Print the credit memo. Save the credit memo. The Available Credit window opens, where you tell QuickBooks how to use this credit.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Accounts Receivable Questions.

A/R And A/P For Same Company In Simply Computer Software

A/R and A/P for Same Company

A/R and A/P for Same Company

So this is what I have, Company A owes Company B $100.00, but Company B owes Company A $100.00 so what do I do in Simply Accounting as far as an entry so we don't have to write checks to each other. In other words, what would the journal entry in Simply Accounting Software be?


DENISE

Comments for A/R And A/P For Same Company In Simply Computer Software

Average Rating starstarstarstarstar

Click here to add your own comments

Dec 07, 2017
Rating
starstarstarstarstar
Accounts Receivable and Accounts Payable
by: Stephanie

Thank you for your question about Accounting for an equal trade between two companies and how to handle the Accounts Receivable and Accounts Payable entries.

This could be considered a trade of services in which no money is changing hands but the expense is still being accounted for.

The entry on both sides would be:

CREDIT A/R to clear the customer invoice
DEBIT Contributions Account (Equity)

CREDIT Contributions Account (Equity)
DEBIT A/P to clear the vendor bill

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Accounts Receivable Questions.

Batching Accounts Receivables

by Tana
(Canada)

Batching Accounts Receivable

Batching Accounts Receivable

Hi there, I have a question regarding the dates you should enter if you are batching entries. We are a charitable organization that takes in donations in a variety of payment methods and batch by payment type. Currently when we date the entry we date them differently:

- donations in cheque form - we date by date of deposit in the bank
- donations in credit card form - we date by the day we called them in
- receiving a cheque from a funder - we date the date we received the cheque in the mail

I am just wondering if the rule of thumb is to be consistent and in this case keep them all the day they were processed/deposited or not

Thanks so much!

Comments for Batching Accounts Receivables

Average Rating starstarstarstarstar

Click here to add your own comments

Dec 07, 2017
Rating
starstarstarstarstar
Accounts Receivable Batch Date
by: Stephanie

Thank you for your question regarding batching Accounts Receivable. Yes, typically the rule of thumb is to be consistent and in your case keep them all the day they were processed/deposited. The main reason for this is because it will make the process of reconciling the books to the bank much easier.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Accounts Receivable Questions.

Beginner Accounts Receivable

by Kendra Quarles
(Russellville, ky US)

Accounts Receivable

Accounts Receivable

Hello Stephanie,

I am going in for an interview for Accounts Receivable position and I am very nervous because this is dealing with the companies money.

I just graduated from college with an Office Systems Technology Degree. I passed my class in Accounting but I was no expert at it. My advisor tried to help me find a job in Accounting but that wasn't something I was interested in.

How do I do Accounts Receivable in a factory setting?

Comments for Beginner Accounts Receivable

Average Rating starstarstarstarstar

Click here to add your own comments

Dec 03, 2017
Rating
starstarstarstarstar
Factory Accounts Receivable
by: Stephanie

Thank you for your question regarding doing Accounts Receivable in a factory setting.

The A/R process is basically the same no matter what industry or setting you are in. The daily/weekly/monthly workflow process is:

- Customer Makes A Purchase
- Customer Invoice is Created
- Print and Send Customer Invoice
- Assess Finance Charge if Late
- Send Finance Charge Invoice if Applicable
- Print Statements for multiple invoices
- Receive and Apply Payments to invoices
- Apply Early Payment Discount if Paid Early
- Record Deposit
- Print A/R Aging Report
- Write Off Uncollectible Invoices
- Print A/R Reports

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Accounts Receivable Questions.

Excel Accounts Receivable and Aging Worksheet

by Dave
(Colorado)

Excel Accounts Receivable and Aging Worksheet

Excel Accounts Receivable and Aging Worksheet

Do you happen to have or know where an accounts receivable aging worksheet created in Excel can be found and downloaded? I am wanting to find one that has the formulas in place, so to see just how it should be setup.

There are several examples out there, but all so far I have located do not include the formulas; just the column headings <30 days; >30days; >60 days and so on. Most of the examples look great, but seem to be missing that key component "the formulas." I realize this is a basic Excel 101 type of request, but a person needs to start somewhere.

I would greatly appreciate any information or assistance where to find such an example.

Thanks every so much.

Dave

Comments for Excel Accounts Receivable and Aging Worksheet

Average Rating starstarstarstarstar

Click here to add your own comments

Dec 07, 2017
Rating
starstarstarstarstar
Accounts Receivable Excel Template
by: Stephanie

Hi Dave,

Thank you for your questions regarding Excel Accounts Receivable and Aging Worksheets. You might want to try the billing statement template download at Excel Bookkeeping Template. It can be used for straight accounts receivable invoice tracking, customer management and general billing.

It has a column for recording the invoice number, a column for recording payments received and an other charges column. Unlike an invoice template, the billing statement template can be used as an accounts receivable ledger. The website also offers many other useful Excel business templates.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Accounts Receivable Questions.

Interest Charge on 30 Days Overdue Accounts Receivable

Interest Finance Charge

Interest Finance Charge

What is the industry standard for interest charged on accounts that are 30/90/120 days overdue?

Comments for Interest Charge on 30 Days Overdue Accounts Receivable

Average Rating starstarstarstarstar

Click here to add your own comments

Dec 03, 2017
Rating
starstarstarstarstar
Finance Charge Standards
by: Stephanie

There doesn't seem to be any across the board industry standard for interest charged on accounts that are 30/90/120 days overdue.

However, the range of terms that I have seen the most in my bookkeeping business doing the books for multiple different types of industries is 1-5% for 30 days overdue, 5-10% for 90 days overdue and 10-15% for 120 days overdue.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Accounts Receivable Questions.

Overdue Accounts Receivable

Overdue Accounts Receivable

Overdue Accounts Receivable

What is a percentage or dollar amount that is added to an overdue accounts receivable considered to be?

Comments for Overdue Accounts Receivable

Average Rating starstarstarstarstar

Click here to add your own comments

Dec 07, 2017
Rating
starstarstarstarstar
Accounts Receivable Finance Charge
by: Stephanie

Thank you for your question about overdue accounts receivable and what the dollar amount this is added to it is usually categorized as.

I believe what you are referring to is typically called a finance charge. You can set terms when sending invoices to customers that state what percentage of finance charge will be added to their invoice if not paid within a designated amount of time.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Accounts Receivable Questions.


Please subscribe to my monthly newsletter, Bookkeeping Basics E-zine. It tells you every month about the new information that I have added, including some great tips and advice from myself and other Bookkeeping Basics readers.

Enter Your E-mail Address
Enter Your First Name (optional)
Then

Don't worry — your e-mail address is totally secure.
I promise to use it only to send you Bookkeeping Basics E-Zine.

Like Bookkeeping-Basics.net?